已经连接上了数据库,但不知道用哪个类来执行sql语句。
Connection Ex1Con=null;
Statement Ex1Stmt=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Ex1Con = DriverManager.getConnection("jdbc:odbc:diago", "", "");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Ex1Stmt = Ex1Con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
StdutempName = rs.getString("StudName");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
rs = Ex1Stmt.executeQuery("select avg(English) from studbasicinfo");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
while(rs.next())
{
System.out.println(rs.getString("English"));
};
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
第二种怎么弄啊
追答你有学过sql查询语句吗?
如果给出String sql="select avg(grade) from table";类似的字符串,执行这条语句即可
看你上面的代码,感觉在用odbc连接数据库,怎么不用Jdbc呢?