jdbcdemo.java

课程设计课程设计课程设计课程设计课程设计课程设计

+/*
 * @(#)JDBCDemo.java	2000/06/18
 */
import java.sql.*;


public class JDBCDemo 
{
	         	
	public static void main(String args[]) 
	{
		try {
			Statement stmt;
        	PreparedStatement pstmt;
			ResultSet rs;
			
			// 加载 jdbc-odbc 桥驱动程序
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			//定义JDBC URL
			String url   = "jdbc:odbc:AADSN";

			//得到与数据库的连接
			Connection con = DriverManager.getConnection (url,"System","sys");
			
			//显示URL和连接信息
			System.out.println("URL: " + url);
			System.out.println("Connection: " + con);
			
			//得到一个Statement对象
			
			pstmt=con.prepareStatement("INSERT INTO sqzf6 ("
				+ "bumensq,zcsq,numsq,mjsq) VALUES(?,?,?,?)");
			String sqbm="qs";
			int sqzc=3;
			int sqnum=2;
			int sqmj=43;
				
				pstmt.setString(1,sqbm);
				pstmt.setInt(2,sqzc);
				pstmt.setInt(3,sqnum);
				pstmt.setInt(4,sqmj);
			
		//	conn = getConnection();
		  //  pstmt = con.prepareStatement();
			//查询数据库中的表DemoTable，得到以test_id排序后的所有记录，
			//并存储在ResultSet对象rs中
			rs = pstmt.executeQuery("SELECT * from sqzf6 order  by  numsq DESC");
			
			while(rs.next())
			{
				
			String bumenhf1 = rs.getString("bumensq");
			int zchf1= rs.getInt("zcsq");
			int numhf1= rs.getInt("numsq");
			int ymjhf1= rs.getInt("mjsq");
				System.out.println("bumensq " + bumenhf1 + "zcsq "+zchf1 + "numsq " + numhf1+"mjsq"+ymjhf1);
			   
			   
			    pstmt=con.prepareStatement("INSERT INTO sqzf4 ("
			    
				+ "bumensq1,zcsq1,numsq1,mjsq1) VALUES(?,?,?,?)");
				pstmt.setString(1,bumenhf1);
				pstmt.setInt(2,zchf1);
				pstmt.setInt(3,numhf1);
				pstmt.setInt(4,ymjhf1);
				pstmt.executeUpdate();
			
 	         
		 
			}


           
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
	}
}