数据库查询（二）

package com.JDBC.proc;

import java.sql.*; 

public class PrepareStatement {
    private static final String DBDRIVER = "com.mysql.jdbc.Driver";
    private static final String DBURL = "jdbc:mysql://localhost:3306/mldn";
    private static final String DBUSER = "root";
    private static final String DBPASS = "root";
    public static void main(String[] args) throws Exception{ 
        
        Connection conn=null; 
        PreparedStatement psmt=null; 
        ResultSet rs=null; 
        Class.forName(DBDRIVER);  
            
        conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
        String sql="select empno,ename " + "from emp " + "where empno=?"; 
        psmt=conn.prepareStatement(sql); 
        psmt.setInt(1, 123); 
                  
        rs=psmt.executeQuery(); 
        while(rs.next()){
            System.out.println(rs.getInt(1)+"---"+rs.getString(2)); 
        } 
        rs.close();
        psmt.close();
        conn.close();
        
    } 
}