在bean中写以下代码
package com.fur.bean;import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import com.fur.dto.CustomerRegDto;public class CustomerRegistBean {
private CustomerRegDto cusdto; private Connection conn; public CustomerRegistBean() {
String classforName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=FurInquire";
String user = "sa";
String pwd = "";
try {
Class.forName(classforName);
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
e.printStackTrace();
} } public void setCustomerRegDto(CustomerRegDto cusdto) {
this.cusdto = cusdto;
} public void customerRegist() throws Exception {
String sql = "insert into Customer values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, cusdto.getCustomerNm());
pstmt.setString(2, cusdto.getCustomerPs());
pstmt.setString(3, cusdto.getSex());
pstmt.setString(4, cusdto.getProblem());
pstmt.setString(5, cusdto.getAnswer());
pstmt.setString(6, cusdto.getCompanyNm());
pstmt.setString(7, cusdto.getRecharger());
pstmt.setString(8, cusdto.getAddress());
pstmt.setString(9, cusdto.getTelephone());
pstmt.setString(10, cusdto.getFax());
pstmt.setString(11, cusdto.getPostCD());
pstmt.setString(12, cusdto.getContactor());
pstmt.setString(13, cusdto.getEmail());
pstmt.setDate(14, new java.sql.Date(new java.util.Date()
.getTime()));
pstmt.setString(15, cusdto.getRequireInfo());
pstmt.executeUpdate();
}
catch (Exception e) {
e.printStackTrace();
throw e;
} }
}
即conn为null 注:我已经导入jdbc驱动程序的包了,mssqlserver.jar,msbase.jar,msutil.jar,将它们放在%tomcat_home%相对目录下的common目录下的lib目录中了, 但是它总提示我import com.microsoft.jdbc.sqlserver.SQLServerDriver;从来没有使用过,我用的是eclipse开发,我也在eclipse中导入了以上三个包
package com.fur.bean;import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import com.fur.dto.CustomerRegDto;public class CustomerRegistBean {
private CustomerRegDto cusdto; private Connection conn; public CustomerRegistBean() {
String classforName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=FurInquire";
String user = "sa";
String pwd = "";
try {
Class.forName(classforName);
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
e.printStackTrace();
} } public void setCustomerRegDto(CustomerRegDto cusdto) {
this.cusdto = cusdto;
} public void customerRegist() throws Exception {
String sql = "insert into Customer values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, cusdto.getCustomerNm());
pstmt.setString(2, cusdto.getCustomerPs());
pstmt.setString(3, cusdto.getSex());
pstmt.setString(4, cusdto.getProblem());
pstmt.setString(5, cusdto.getAnswer());
pstmt.setString(6, cusdto.getCompanyNm());
pstmt.setString(7, cusdto.getRecharger());
pstmt.setString(8, cusdto.getAddress());
pstmt.setString(9, cusdto.getTelephone());
pstmt.setString(10, cusdto.getFax());
pstmt.setString(11, cusdto.getPostCD());
pstmt.setString(12, cusdto.getContactor());
pstmt.setString(13, cusdto.getEmail());
pstmt.setDate(14, new java.sql.Date(new java.util.Date()
.getTime()));
pstmt.setString(15, cusdto.getRequireInfo());
pstmt.executeUpdate();
}
catch (Exception e) {
e.printStackTrace();
throw e;
} }
}
即conn为null 注:我已经导入jdbc驱动程序的包了,mssqlserver.jar,msbase.jar,msutil.jar,将它们放在%tomcat_home%相对目录下的common目录下的lib目录中了, 但是它总提示我import com.microsoft.jdbc.sqlserver.SQLServerDriver;从来没有使用过,我用的是eclipse开发,我也在eclipse中导入了以上三个包
解决方案 »
- jsp 两个下拉框联动
- 高分求用java做一个读取文件属性程序!
- 如何给你一个项目添加Struts框加?
- 公文流转痕迹保留时如何通过控件打开指定文档?再线等?高分送
- 100分,请问servlet.getServletContext()和getServletConfig(),什么意思和用法,解决了马上给分!
- doOption()是什么方法?
- 为什么我的代码总是不能达到预期的效果??请高手赐教!!
- 我准备申请的虚拟JSP/Servlet主机用的是Jetty服务器,我没听到过,大家评价一下
- 求救,数据库不容许镶套使用
- JSP服务器问题
- java.util.data;不能用
- 为什么在提交表单的时候密码接收不到啊!
public Connection conn=null;
System.out.println(conn.isClosed());看看结果是true还是false,如果没有输出,可能表示发生ClassNotFoundException错误了。
import java.util.*;
public class DbBean
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=asdf";
public Connection sqlCon=null;
public Statement sqlStmt=null;
public DbBean()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
sqlCon=DriverManager.getConnection(url,"sa","");
sqlStmt=sqlCon.createStatement();
sqlCon.setAutoCommit(true);
}
catch(Exception e)
{
System.out.println("数据库错误");
}
}记得结贴给分。
把这个放到WEB-INF下吧