JDBC与Oracle数据库连接

1.基础：连接语句

public class LoginDaoImpl implements LoginDao {
	PreparedStatement pstmt=null;
	Connection conn=null;
	ResultSet rs=null;
	int a;
	public int sureUser(String uname,String pwd){
		try {
			//获取连接 加载驱动,将想要连接的数据库驱动加载到jvm中，加载后会将Driver类的实例注册到DriverManager类中
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//得到连接
			conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","SCOTT","Admin");
			//创建preparedstatement预编译语句
			pstmt=conn.prepareStatement("select * from users where username=? and password=?");
			pstmt.setString(1, uname);
			pstmt.setString(2, pwd);
			//执行操作
			rs=pstmt.executeQuery();
			//根据结果做处理
			if(rs.next()){
				System.out.println("到这里了");
				return 1;
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
try {
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
		return 0;
	}

}