lab66.java

来自「这个适用于初学者,JDBC连接MYSQL,这些是JDBC一些测试程序」· Java 代码 · 共 37 行

package jdbc.jdbc;
import java.sql.*;
public class Lab66 {
	public static void main(String[] args) {
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		try {
			con=JdbcUtil.getConnection();
			String sql="insert into wen7_23 values(?,?)";
			ps=con.prepareStatement( sql);
			ps.setInt( 1,8);
			ps.setString( 2,"wen7_23");
			ps.executeUpdate() ;
			JdbcUtil.release( ps);
			
			sql="select * from wen7_23";
			ps=con.prepareStatement( sql);
			rs=ps.executeQuery() ;
			StringBuffer sb=new StringBuffer();
			while(rs.next() ){
				sb.append( "id="+rs.getInt( 1)+"\t");
				sb.append( "name="+rs.getString( 2)+"\n");
			}
			System.out.println(sb.toString() ) ;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			JdbcUtil.release( rs,ps,con);
		}
		
	}

}