//链接数据库
Class.forName("oracle.jdbc.driver.OracleDriver");
//得到链接
ct=DriverManager.getConnection("jdbc:oracle:[email protected]:1521:myora1”,”scott”,”tiger");
//创建一个statement
sm=ct.createStatement();
rs=sm.executeQuery("select top 1 * from myuser where username=' "+u+" ' and passed=' "+p+" ' " );
这段代码有错吗。配置应该都对的,但是好像没有访问到数据库
Class.forName("oracle.jdbc.driver.OracleDriver");
//得到链接
ct=DriverManager.getConnection("jdbc:oracle:[email protected]:1521:myora1”,”scott”,”tiger");
//创建一个statement
sm=ct.createStatement();
rs=sm.executeQuery("select top 1 * from myuser where username=' "+u+" ' and passed=' "+p+" ' " );
这段代码有错吗。配置应该都对的,但是好像没有访问到数据库
ct=DriverManager.getConnection("jdbc:oracle:[email protected]:1521:myora1”,”scott”,”tiger"); 还有就是,Oracle里没有top 1这种语法的,你确定你的代码执行没有错?
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = DriverManager.getConnection(url, "zbt", "zbt");
String sql = "select real_name from t_user where user_name= ?";
PreparedStatement pstm = conn.prepareStatement(sql);
String xx = "111";
pstm.setString(1, xx);
ResultSet rs = pstm.executeQuery();
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
pstm.close();
conn.close(); } catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}();
还是这位仁兄看的很清楚,oracle里没有top的用法