testdb.java

java swing 和sql server 数据库做的 图书管理系统

package bookmanager.bean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class TestDB {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		//1
		while(true){
       String sql="insert into T_USER(loginid,name,duty,pwd)values(?,?,?,?)";
       Object[] obj=new Object[]{"a","b","c","d"};
       DbUtil.executeUpdate(sql,obj);
       //2
       sql="insert into T_USER(loginid,name,duty,pwd)values('1','2','3','4')";
       DbUtil.executeUpdate(sql);
       //3
       sql="select * from t_user";
       ResultSet set=DbUtil.executeQuery(sql);
       set.next();
       System.out.println("count==="+set.getString("name"));
       DbUtil.closeConnection();
       //4
       int i=DbUtil.executeCount("select count(*) from t_user");
       System.out.println("����:"+i+"���¼");
       //5
       sql="update t_user set name=?";
       DbUtil.executeUpdate(sql,new Object[]{"�޸ijɹ�"});
		}
	}

}