JAVA数据库增删改查

1、package JDBC;public class Student /*增加*/public void jdbc_add(try String url ="jdbc:sqlserver:/localhost:1433;DatabaseName=Student"Connection conn=DriverManager.getConnection(url,"sa","123"String sq1="insert into Information(Studentnumber,Studentname, Studentclass,S

2、tudentsex, Studentadd values(?,?,?,?,?;"PreparedStatement ps =conn.prepareStatement(sq1;ps.setObject(1,"1010"ps.setObject(2," 大禹"ps.setObject(3,"10"ps.setObject(4," 男"ps.setObject(5," 上海"int r=ps.executeUpdate(;ps.close(;conn.close(;if(r>0cat

3、ch (Exceptione e.printStackTrace(;/*删除*/public void jdbc_del(try String url="jdbc:sqlserver:/localhost:1433;databasename=Student"Connection conn=DriverManager.getConnection(url,"sa","123"Statement st=conn.createStatement(;String sql="deletefrom Information where St

4、udentname='杨伟'" int flag=st.executeUpdate(sql;if(flag>0catch (Exceptione e.printStackTrace(;/*修改*/public void jdbc_cha(try /1加载驱动类/2.定义字符串String url="jdbc:sqlserver:/localhost:1433;databasename=Student"/3.建立连接Connection conn=DriverManager.getConnection(url,"sa",&q

5、uot;123"/4.定义SQL 语句修改String sql="updateInformation set Studentname=?where Studentnumber=?"PreparedStatement ps=conn.prepareStatement(sql;ps.setObject(1," 杨伟"ps.setObject(2,"1002"int flag=ps.executeUpdate(;if(flag>0catch (Exceptione e.printStackTrace(;/*查询*parama

6、rgs*/public void jdbc_find(try String studentname =input.next(;String sql="select*fromInformation where Studentname=?;"PreparedStatement ps=conn.prepareStatement(sql;ps.setObject(1,studentname;ResultSet rs=ps.executeQuery(;while (rs.next(int flag=ps.executeUpdate(;rs.close(;ps.close(;conn.close(;if(flag>0input.close(;catch (Exceptione e.printStackTrace(;public static void mai