Question

求jsp连接mysql的完整代码及说明！

假设mysql下有一数据库叫student，表名称叫st_info,含有两个字段，名为name及sex，求教如何连接并读取st_info中的数据。

Answer 1

我给你 后台通用的增删改 方法 ， sql 语句我就写了，自己去调用吧
<%

private static Connection con = null;
private static String CONSTR = "jdbc:mysql://localhost:3306/student";
private static String CLASSNAME = "com.mysql.jdbc.Driver";
private static PreparedStatement prst = null;
private static ResultSet rs = null;

/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
* @throws ClassNotFoundException
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
*/

/**
* 获得连接
* @return
* @throws ClassNotFoundException
* @throws SQLException
* @throws InstantiationException
* @throws IllegalAccessException
*/
public Connection getConnection(){
try {
Class.forName(CLASSNAME).newInstance();//加载驱动
con = DriverManager.getConnection(CONSTR, "数据库用户名","密码");//得connection
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}

/**
* 增、删、改
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
* @throws ClassNotFoundException
*/
public void insertUpdate(String sql,Object...param){
getConnection();
try {
prst = con.prepareStatement(sql);
bindParam(param);
prst.executeUpdate(sql);

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

/**
* 查找方法
* @param sql
* @param param
* @return
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
* @throws ClassNotFoundException
*/
public ResultSet search(String sql,Object...param){
getConnection();
try {
prst = con.prepareStatement(sql);
bindParam(param);
rs = prst.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}

/**
* 绑定参数
* @param param
* @throws SQLException
*/
private void bindParam(Object... param) throws SQLException {
if(param!=null){

for(int i=0;i<param.length;i++){
if(param[i] instanceof java.util.Date){
java.util.Date dd = (java.util.Date)param[i];
java.sql.Date sd = new java.sql.Date(dd.getTime());
prst.setDate(i,sd);
}else{
prst.setObject(i,param[i]);
}
}
}
}

/**
* 释放资源
* @throws SQLException
*/
public void realse(ResultSet rs) throws SQLException{
if(rs!=null){
rs.close();
}
if(prst!=null){
prst.close();
}
if(con!=null){
con.close();
}

}

public void realse() throws SQLException{
realse(null);
}
%>