java操作sql server数据添加，修改，删除记录

java操作sql server数据添加，修改，删除记录

package e20_05;

import java.sql.*;


public class Renewal {
	static Connection con;
	static PreparedStatement sql;
	static ResultSet res;
	public Connection getConnection(){
		try{
			Class.forName("net.sourceforge.jtds.jdbc.Driver"); //数据库驱动加载
			//数据库驱动加载方法：http://blog.csdn.net/txwtech/article/details/62245346
			System.out.println("数据库驱动加载成功");
			con=DriverManager.getConnection("jdbc:jtds:"+
					 "sqlserver://localhost:1433/db_jdbc","sa","123456");//数据库连接，sa是登录名，后面的是数字是密码，db_jdbc是数据库名字
					System.out.println("数据库连接成功");
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
	}
	public static void main(String[] args){
	Renewal c=new Renewal();
		con=c.getConnection();
		try{
		
	
		sql=con.prepareStatement("select * from tb_stu");
		//sql.setInt(1,101);
		res=sql.executeQuery();
		System.out.println("执行增加，修改，删除前数据---row data");
	
		while(res.next()){
			//String id=res.getString("id");
			String id=res.getString(1); //p366 详解
			String name=res.getString("name");
			String sex=res.getString("sex");
			String birthday=res.getString("birthday");
			System.out.print("编号:"+id);
			System.out.print("   姓名:"+name);
			System.out.print("   性别："+sex);
			System.out.println("   生日:"+birthday);  //。。。。。。。。
		}
		sql=con.prepareStatement("insert into tb_stu"
				+" values(?,?,?,?)");     //报错“列名或所提供值的数目与表定义不匹配。”，数据库中定义了4列，value后面的问号个数就应该是4个

		sql.setString(1, "66"); 
		sql.setString(2,"张一");
		sql.setString(3, "m");
		sql.setString(4, "2008-12-1");
		sql.executeUpdate();
		
		 sql=con.prepareStatement("select *from tb_stu");
		 res=sql.executeQuery();
		System.out.println("执行增加，修改，删除前数据---new data");
		
		 while(res.next()){
		    	String id=res.getString(1); //p366 详解
				String name=res.getString("name");
				String sex=res.getString("sex");
				String birthday=res.getString("birthday");
				System.out.print("编号:"+id);
				System.out.print("   姓名:"+name);
				System.out.print("   性别："+sex);
				System.out.println("   生日:"+birthday);  //。。。
		    	
		    }
		
		sql=con.prepareStatement("update tb_stu set birthday "
				+"= ? where id=(select min(id) from tb_stu)");
		sql.setString(1, "2007-12-1");
		sql.executeUpdate();
		
		 sql=con.prepareStatement("select *from tb_stu");
		    res=sql.executeQuery();
		    System.out.println("执行增加，修改，删除后的数据---changed birthday data");
		    while(res.next()){
		    	String id=res.getString(1); //p366 详解
				String name=res.getString("name");
				String sex=res.getString("sex");
				String birthday=res.getString("birthday");
				System.out.print("编号:"+id);
				System.out.print("   姓名:"+name);
				System.out.print("   性别："+sex);
				System.out.println("   生日:"+birthday);  //。。。
		    	
		    }
		
	    Statement stmt=con.createStatement();
	    stmt.executeUpdate("delete from tb_stu where id="   //...delete
	    		+"(select min(id) from tb_stu)");
	 //   sql.setInt(1, 1);
	 //   sql.executeUpdate();
	    
	    //show data
	    
	    sql=con.prepareStatement("select *from tb_stu");
	    res=sql.executeQuery();
	    System.out.println("执行增加，修改，删除后的数据---after deleted  data");
	    while(res.next()){
	    	String id=res.getString(1); //p366 详解
			String name=res.getString("name");
			String sex=res.getString("sex");
			String birthday=res.getString("birthday");
			System.out.print("编号:"+id);
			System.out.print("   姓名:"+name);
			System.out.print("   性别："+sex);
			System.out.println("   生日:"+birthday);  //。。。
	    	
	    }
		
		}catch(Exception e){
			e.printStackTrace();
		}
		}
}