运用JDBC知识做一个学生表，表中有编号，名称，性别，年龄，地址，再遍历学生表

create table student(

Id int primary key identity(1, 1),

Name nvarchar (20) ,

Age int check (Age>5 and Age<60),

sex nvarchar (10) check(sex='男'or sex='女'),

addressName nvarchar (20)

)

insert into student values('诗书',19,'男','江西')

insert into student values('江唯',20,'女','湖南')

insert into student values('嘉怡',21,'女','上海')

insert into student values('画唱',22,'男','北京')

insert into student values('点赞',20,'男','武汉')

select * from student

delete  from student

drop table student

package JDBC;

import java.sql.*;

public class bianLIStudentBiao {

public static void main(String[] args) {

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection con=DriverManager.getConnection("jdbc:sqlserver://DESKTOP-49FTFSP;"

+ "databaseName=stud","sa","1234abcd");

String sql="select * from student";

Statement sta=con.createStatement();

ResultSet res=sta.executeQuery(sql);

System.out.println("编号     "+"姓名"+"     性别"+"       年龄"+"        地址");

while(res.next()){

System.out.print(res.getObject("Id")+"   ");

System.out.print(res.getObject("Name")+"   ");

System.out.print(res.getObject("sex")+"   ");

System.out.print(res.getObject("Age")+"   ");

System.out.print(res.getObject("addressName")+"   ");

System.out.println();

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}