Question

老是报错！！The method PreparedStatement(String) is undefined for the type Connection

把pstmt=conn.preparedStatement(sql)改成pstmt=conn.prepareStatement(sql)之后，现在错误变成这样了

Answer 1

String sql="select myname ,myage from mypersons where 1=1";

或者
String sql="select myname ,myage from mypersons where myname =？";
PreparedStatement statement=connect.prepareStatement(sql);
statement.setString(1, "sss");
ResultSet results=statement.executeQuery();

追问

我是这样写的：

追答

你的 sql有问题 根本没有where条件 像我那样写。

String sql="select myname ,myage from mypersons where 1=1";

Answer 2

String sql = "select * from user where id = ?"
PrepatedStatement pstmt = connection.preparestatement(sql);
pstmt.setInt(1,id);

Answer 3

你把代码贴出来看看

追问

追答

把pstmt位置的内容改成这样的：pstmt = conn.preparedStatement(sql);
rs = pstmt.executeQuery();

追问

改过来了 现在还是提示错误的，The method preparedStatement(String) is undefined for the type Connection

追答

你的驱动类好像也错了吧，是oracle.jdbc.OracleDriver