public class DBCon {
private static String dbDriver="com.mysql.jdbc.Driver";
private String dbUrl="jdbc:Access:///D:/java/english.mdb";
private Connection conn=null;
public Connection getConnection()
{
try {
Class.forName(dbDriver);
conn=DriverManager.getConnection(dbUrl,"","");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public ResultSet doQuery(String sql,Object[] params)
{
ResultSet rs=null;
conn=this.getConnection();
try {
PreparedStatement pstmt=conn.prepareStatement(sql);
for(int i=0;i<params.length;i++)
{
pstmt.setObject(i+1, params[i]);
}
rs=pstmt.executeQuery();
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
主要是看不懂后面这个public ResultSet doQuery(String sql,Object[] params)方法。
问题1:
public ResultSet doQuery(String sql,Object[] params)这是个什么鬼?我百度了半天没找到有doQuery这个方法,此外后面参数里面 Object[] params又是指什么?
问题2:
conn=this.getConnection();里this.getConnection()是指public Connection getConnection()这个方法吗?
private static String dbDriver="com.mysql.jdbc.Driver";
private String dbUrl="jdbc:Access:///D:/java/english.mdb";
private Connection conn=null;
public Connection getConnection()
{
try {
Class.forName(dbDriver);
conn=DriverManager.getConnection(dbUrl,"","");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public ResultSet doQuery(String sql,Object[] params)
{
ResultSet rs=null;
conn=this.getConnection();
try {
PreparedStatement pstmt=conn.prepareStatement(sql);
for(int i=0;i<params.length;i++)
{
pstmt.setObject(i+1, params[i]);
}
rs=pstmt.executeQuery();
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
主要是看不懂后面这个public ResultSet doQuery(String sql,Object[] params)方法。
问题1:
public ResultSet doQuery(String sql,Object[] params)这是个什么鬼?我百度了半天没找到有doQuery这个方法,此外后面参数里面 Object[] params又是指什么?
问题2:
conn=this.getConnection();里this.getConnection()是指public Connection getConnection()这个方法吗?