JAVA数据库增删改查(精)

1、package JDBC;import java.sql.C onn ectio n;import java.sql.DriverMa nager;import java.sql.PreparedStateme nt;import java.sql.ResultSet;import java.sql.Stateme nt;import java.util.Sca nner;public class Stude nt /*增加*/public void jdbc_add(try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver;

2、Stri ng url =jdbc:sqlserver:/localhost:1433;DatabaseName=Stude nt;Connection conn=DriverManager.getConnection(url,sa,123;String sq1= insert into In formati on( Stude ntnu mber,Stude ntn ame, Stude ntclass.Studentsex, Studentadd values(?,?,?,?,?; PreparedStateme nt ps=conn .prepareStateme nt(sq1; ps.

3、set0bject(1,1010;ps.setObject(2,大禹；ps.setObject(3,10;ps.setObject(4,男;ps.setObject(5,上海;int r=ps.executeUpdate(;ps.close(;conn. close(;if(r0System.out.println(插入成功!;elseSystem.out.pri ntl n(插入失败！;catch (Excepti one e.pri ntStackTrace(;/*删除*/public void jdbc_del(try Class.forName(com.microsoft.sqlser

4、ver.jdbc.SQLServerDriver;Stri ng url=jdbc:sqlserver:/localhost:1433;database name=Stude nt;C onnectio nconn=DriverMa nager.getCo nn ectio n(url,sa,123;Stateme nt st=c onn. createStateme nt(;Stri ng sql=deletefrom In formatio n where Stude ntn ame=/ 伟;intflag=st.executeUpdate(sql;if(flag0System.out.p

5、ri ntln (删除成功！;elseSystem.out.pri ntl n(删除失败！;catch (Exceptio ne e.pri ntStackTrace(;/*修改*/public void jdbc_cha(try 1 加载驱动类Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver;2定义字符串Stri ng url=jdbc:sqlserver:/localhost:1433;database name=Stude nt;/建 立连接Connection conn=DriverManager.getConnect

6、ion(url,sa,123;4定义 SQL 语句修改String sql=updatel nformatio n set Stude ntn ame=?whereStude ntnu mber=?;PreparedStateme nt ps=co nn .prepareStateme nt(sql;ps.setObject(1,杨伟;ps.setObject(2,1002;int flag=ps.executeUpdate(;if(flag0System.out.pri ntl n(修改成功！;elseSystem.out.pri ntl n(修改失败！;catch (Exceptio ne

7、 e.pri ntStackTrace(;/*查询*paramargs*/public void jdbc_fi nd(try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver;Stri ngurl=jdbc:sqlserver:/localhost:1433;database name=Stude nt;C onn ectio nconn=DriverMa nager.getCo nn ectio n(url,sa,123;Sca nnerin put=n ewSca nn er(System.i n;System.out.

8、pri nt(请输入姓名：;String stude ntn ame =in put. next(;String sql=select*fromlnformation where Studentname=?;PreparedStatementps=c onn .prepareStateme nt(sql;ps.setObject(1,stude ntn ame;ResultSet rs=ps.executeQuery(;while (rs. next(System.out.pri ntln(您查询的信息为：+rs.getObject(stude ntn ame;int flag=ps.executeUpdate(;rs.close(;ps.close(;conn. close(;if(flag0elseSystem.out.pri ntln (”查询失败！您要查询的信息不存在！in put.close(;catch (Excepti one e.pri ntStackT