運(yùn)用JDBC知識做一個學(xué)生表，表中有編號，名稱，性別，年齡，地址，再遍歷學(xué)生表

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('點(diǎn)贊',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();

}

}

}