准备工作(导JDBC包C:\Users\Desk\AppData\Local\MyEclipse Professional\binary\com.sun.java.jdk.win32.x86_64_1.6.0.u43\jre\lib\ext)
1、建立一个数据库CollegeDB
sql语句
create database CollegeDB
在CollegeDB中建立一个表tStudent,tStudent中有学号、姓名、年龄、性别
sql语句
create table tStudent(
sno varchar(20),
sname varchar(20),
age int,
sex varchar(4)
)
使用JDBC向表中插入3条数据,然后在SQLServer中查看是否成功。
001 tom 14 男
002 jack 15 男
003 king 21 男
insert into tStudent values('001','tom','14','男');
insert into tStudent values('002','jack','15','男');
insert into tStudent values('003','king','21','男');
JDBC代码
package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Jdbc {
public static void main(String[] args) {
String sql01="insert into tStudent values('001','tom','14','男')";
String sql02="insert into tStudent values('002','jack','15','男')";
String sql03="insert into tStudent values('003','king','21','男')";
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=CollegeDB","sa","1");
Statement stat=conn.createStatement();
stat.execute(sql01);
stat.execute(sql02);
stat.execute(sql03);
conn.close();
System.out.println("恭喜你,成功了!");
}catch(Exception e){
e.printStackTrace();//输出错误信息
}
}
}
结果截图:
3.删除tom,然后在SQLServer中查看是否成功。
JDBC代码
package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Jdbc {
public static void main(String[] args) {
String sql01="insert into tStudent values('001','tom','14','男')";
String sql02="insert into tStudent values('002','jack','15','男')";
String sql03="insert into tStudent values('003','king','21','男')";
String sql04="delete from tStudent where sname='tom'";
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=CollegeDB","sa","1");
Statement stat=conn.createStatement();
stat.execute(sql01);
stat.execute(sql02);
stat.execute(sql03);
stat.execute(sql04);
conn.close();
System.out.println("恭喜你,成功了!");
}catch(Exception e){
e.printStackTrace();//输出错误信息
}
}
}
数据库结果截图:
4、将jack的年龄改为16,然后在SQLServer中查看是否成功。
String sql05="update tStudent set age=16 where sname='jack'";
5.查询所有数据,并输出。
String sql05="select * from tStudent";
ResultSet rs=stat.executeQuery(sql05);
while(rs.next()){
System.out.println("学号"+rs.getString(1));
System.out.println("姓名"+rs.getString(2));
System.out.println("年龄"+rs.getInt(3));
System.out.println("性别"+rs.getString(4));
}