JDBC连接数据库

final String DBDRIVER   = "oracle.jdbc.driver.OracleDriver";
//MySQL:com.mysql.jdbc.Driver
final String URL        = "jdbc:oracle:thin:@localhost:1521:test";
//jdbc:mysql://localhost:3306/test
final String DBUSER     = "scott";
final String DBPASSWORD = "tiger";

Connection conn = null;
PreparedStatement pstmt = null;
resultSet rs = null;

String sql = "select name from person where id = ? and password = ?";
try
{
   Class.forName(DBDRIVER)
   conn = DriverManager.getConnection(URL, DBUSER, DBPASSWORD);
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(0,id);
   pstmt.setString(1,password);
   rs = pastmt.executeQuery();
   
   if(rs.next())
   {
     ........
   }
   rs.close() ;
   pstmt.close() ;
   conn.close() ;

}
catch (SQLException e)
{
}