运行以下hecuo.jsp文件时为何出错:1.hecuo.jsp文件:
运行以下hecuo.jsp文件时为何出错:
1.hecuo.jsp文件:
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
核错页面lianjiedim lianjie=null;
try{
String mystr="select * from zichan";
lianjie=new lianjiedim();
PreparedStatement pmt=lianjie.getConnection().prepareStatement(mystr);
pmt.executeQuery();
pmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
lianjie.close();
}
%>
操作成功!
2..lianjiedim.java文件:
package xitongpk;
import java.sql.* ;
// 主要功能就是连接数据库、关闭数据库
public class lianjiedim{
private Connection conn = null ;
//构造方法,加载驱动
public lianjiedim(){
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost/myfamily","root","120612");
}
catch (ClassNotFoundException e){
System.out.println("加载驱动失败");
}
catch(SQLException e){
e.printStackTrace();
}
}
// 取得数据库连接
public Connection getConnection(){
return conn ;
}
// 关闭数据库连接
public void close(){
try{
conn.close() ;
}catch (Exception e){
System.out.println("数据库连接关闭失败");
}
}
}
(注意:单独运行以下jsp文件时能正常运行:
Connection con=null;
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/myfamily","root","120612");
Statement stat=con.createStatement();
String cao2="select * from zichan";
ResultSet rs=stat.executeQuery(cao2);
while(rs.next()){
out.println(rs.getString(1)+" "+rs.getString(2));
out.println("
");
}
}
catch(ClassNotFoundException e){
out.println("没有找到驱动");
}
catch(SQLException e){
e.printStackTrace();
}
n=n+1;
%>
)
谢谢!!我真的搞了好几个小时了,都搞不定……希望有哪位仁兄能帮个忙。谢谢!!
展开