问一个javabean连接数据库的问题!! gs.ContactBean contact= new ContactBean(); contact.adduserinfo(userID,courseno,coursename,teachername,teacherno,datetime,score); } 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 javabean代码:package gs;import java.sql.*;public class ContactBean{ private Connection con; public ContactBean() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:xkxt"); } catch(Exception e) { e.printStackTrace(); } } public void addcourseinfo(String courseno,String coursename,String xino,String xiname,String teacherno, String teachername,String datetime,String score,String Kone,String Sone) { try { PreparedStatement pstmt=con.prepareStatement("insert into courseinfo values(?,?,?,?,?,?,?,?,?,?)"); pstmt.setString(1,courseno); pstmt.setString(2,coursename); pstmt.setString(3,xino); pstmt.setString(4,xiname); pstmt.setString(5,teacherno); pstmt.setString(6,teachername); pstmt.setString(7,datetime); pstmt.setString(8,score); pstmt.setString(9,Kone); pstmt.setString(10,Sone); pstmt.execute(); //con.close(); } catch(Exception e) { e.printStackTrace(); } } public void addteacherinfo(String teacherno,String teachername,String sex,String birthday,String phone, String email,String ordorer,String place) { try { PreparedStatement pstmt=con.prepareStatement("insert into teacherinfo values(?,?,?,?,?,?,?,?)"); pstmt.setString(1,teacherno); pstmt.setString(2,teachername); pstmt.setString(3,sex); pstmt.setString(4,birthday); pstmt.setString(5,phone); pstmt.setString(6,email); pstmt.setString(7,ordorer); pstmt.setString(8,place); pstmt.execute(); //con.close(); } catch(Exception e) { e.printStackTrace(); } } public void adduserinfo(String userID,String courseno,String coursename,String teachername,String teacherno, String datetime,String score) { try { PreparedStatement pstmt=con.prepareStatement("insert into userinfo values(?,?,?,?,?,?,?)"); pstmt.setString(1,userID); pstmt.setString(2,courseno); pstmt.setString(3,coursename); pstmt.setString(4,teachername); pstmt.setString(5,teacherno); pstmt.setString(6,datetime); pstmt.setString(7,score); pstmt.execute(); //con.close(); } catch(Exception e) { e.printStackTrace(); } } public ResultSet getmessage(String sql) { try { Statement stm=con.createStatement(); ResultSet result=stm.executeQuery(sql); return result; } catch(Exception e) { return null; } } public void closecon() { try { con.close(); } catch(Exception e) { e.printStackTrace(); } }} ResultSet rst=contact.getmessage(str2); while(rst.next()) { String userID = "200"; String courseno = str1; String coursename = rst.getString("coursename"); String teacherno = rst.getString("teacherno"); String teachername = rst.getString("teachername"); String datetime = rst.getString("datetime"); String score = rst.getString("score");如果我没理解错的话,楼主是想要先进行查询得到数据集ResultSet,再将得到的数据集中的数据插入数据库中有一点看法,不过还是楼主把出错信息贴出来,免得我瞎猜 delcare two different Statement,that's ok! 异常信息是:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt 连接数据前把连接清除一哈,if (conn!=null) {conn.close();conn = null;} 这招我也试过了,但我这里每次一调用conn.close()后,TOMCAT服务器程序就自动关闭了,奇怪了!! FCKEditor如何响应鼠标事件 如何使得XML文件读写同步 连接池问题!!!!! 分页问题,查询参数传递 struts 的简单问题 Connection的回收,JavaBean写连接池,请指教,分奉上! linux下mysql问题 请教!!!可不可以对数组循环打印出来的数据,进行分页啊!!! 哪位老大能给小弟一个jsp通过存储过程操作SQL2000数据库的完整的类(添加/删除/修改/输入输出参数),给500分,急,多谢! 为什么我的中文不可以显示? 关于setObject和setXXX性能的比较 50分问事务划分问题,急
import java.sql.*;public class ContactBean
{
private Connection con;
public ContactBean()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:xkxt");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void addcourseinfo(String courseno,String coursename,String xino,String xiname,String teacherno,
String teachername,String datetime,String score,String Kone,String Sone)
{
try
{
PreparedStatement pstmt=con.prepareStatement("insert into courseinfo values(?,?,?,?,?,?,?,?,?,?)");
pstmt.setString(1,courseno);
pstmt.setString(2,coursename);
pstmt.setString(3,xino);
pstmt.setString(4,xiname);
pstmt.setString(5,teacherno);
pstmt.setString(6,teachername);
pstmt.setString(7,datetime);
pstmt.setString(8,score);
pstmt.setString(9,Kone);
pstmt.setString(10,Sone);
pstmt.execute();
//con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void addteacherinfo(String teacherno,String teachername,String sex,String birthday,String phone,
String email,String ordorer,String place)
{
try
{
PreparedStatement pstmt=con.prepareStatement("insert into teacherinfo values(?,?,?,?,?,?,?,?)");
pstmt.setString(1,teacherno);
pstmt.setString(2,teachername);
pstmt.setString(3,sex);
pstmt.setString(4,birthday);
pstmt.setString(5,phone);
pstmt.setString(6,email);
pstmt.setString(7,ordorer);
pstmt.setString(8,place);
pstmt.execute();
//con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void adduserinfo(String userID,String courseno,String coursename,String teachername,String teacherno,
String datetime,String score)
{
try
{
PreparedStatement pstmt=con.prepareStatement("insert into userinfo values(?,?,?,?,?,?,?)");
pstmt.setString(1,userID);
pstmt.setString(2,courseno);
pstmt.setString(3,coursename);
pstmt.setString(4,teachername);
pstmt.setString(5,teacherno);
pstmt.setString(6,datetime);
pstmt.setString(7,score);
pstmt.execute();
//con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public ResultSet getmessage(String sql)
{
try
{
Statement stm=con.createStatement();
ResultSet result=stm.executeQuery(sql);
return result;
}
catch(Exception e)
{
return null;
}
}
public void closecon()
{
try
{
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
{
String userID = "200";
String courseno = str1;
String coursename = rst.getString("coursename");
String teacherno = rst.getString("teacherno");
String teachername = rst.getString("teachername");
String datetime = rst.getString("datetime");
String score = rst.getString("score");
如果我没理解错的话,楼主是想要先进行查询得到数据集ResultSet,再将得到的数据集中的数据插入数据库中有一点看法,不过还是楼主把出错信息贴出来,免得我瞎猜
if (conn!=null) {
conn.close();
conn = null;
}
奇怪了!!