![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
java jsp 连接数据库问题
importjava.sql.*;importjava.text.SimpleDateFormat;importjava.sql.PreparedStatement;im...
import java.sql.*;
import java.text.SimpleDateFormat;
import java.sql.PreparedStatement;
import java.util.Date;
public class ConnectionManagerDB {
public ConnectionManagerDB() {
}
private static Connection conn;
private static final String Driver_Class="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动名称地址
private static final String Database_url="jdbc:microsoft:sqlsever://localhost:1433/BaseDao";//数据库加载地址
private static final String user="sa";
private static final String password="sa";
//创建连接
public static PreparedStatement padsment( ) {
PreparedStatement padsment=null;
try {
Class.forName(Driver_Class);
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//驱动名称地址
String sql="insert into TBL_USER(uName,Upass,head,regTime,gebder)values(?,?,?,?,?)";
SimpleDateFormat Format =new SimpleDateFormat("yyy-mm-dd hh:mm:ss");
try {
Connection conn = DriverManager.getConnection(Database_url,user,password);
padsment = conn.prepareStatement(sql);
padsment.setString(1,"'名字'");
padsment.setString(2,"123456");
padsment.setString(3,"123");
padsment.setString(3,Format.format(new Date()));
padsment.setString(4,"123");
padsment.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
System.out.println("添加结果是"+padsment);
CloseConnection(conn);
ClosePreparedStatement(padsment);
}
return padsment;
}
public static void CloseConnection(Connection DBconn){
try {
if(DBconn!=null && (!DBconn.isClosed())){
DBconn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void CloseResult(ResultSet res){
if(res!=null){
try {
res.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
res=null;
}
}
public static void ClosePreparedStatement (PreparedStatement pastment){
if(pastment!=null){
try {
pastment.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pastment=null;
}
}
}
错误提示是!数据库是SQL2005不是企业版`
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlsever://localhost:1433/BaseDao
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at ConnectionManagerDB.padsment(ConnectionManagerDB.java:40)
at Test.main(Test.java:18)
添加结果是null
- -没人帮下我吗!大哥大姐!我很纠结额你让我叫什么都行!能帮我解决下吗!一下午 了~我是不折不扣的菜鸟额!
public class Test {
public Test() {
// TODO Auto-generated constructor stub
}
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
ConnectionManagerDB.padsment();
}
} 展开
import java.text.SimpleDateFormat;
import java.sql.PreparedStatement;
import java.util.Date;
public class ConnectionManagerDB {
public ConnectionManagerDB() {
}
private static Connection conn;
private static final String Driver_Class="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动名称地址
private static final String Database_url="jdbc:microsoft:sqlsever://localhost:1433/BaseDao";//数据库加载地址
private static final String user="sa";
private static final String password="sa";
//创建连接
public static PreparedStatement padsment( ) {
PreparedStatement padsment=null;
try {
Class.forName(Driver_Class);
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//驱动名称地址
String sql="insert into TBL_USER(uName,Upass,head,regTime,gebder)values(?,?,?,?,?)";
SimpleDateFormat Format =new SimpleDateFormat("yyy-mm-dd hh:mm:ss");
try {
Connection conn = DriverManager.getConnection(Database_url,user,password);
padsment = conn.prepareStatement(sql);
padsment.setString(1,"'名字'");
padsment.setString(2,"123456");
padsment.setString(3,"123");
padsment.setString(3,Format.format(new Date()));
padsment.setString(4,"123");
padsment.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
System.out.println("添加结果是"+padsment);
CloseConnection(conn);
ClosePreparedStatement(padsment);
}
return padsment;
}
public static void CloseConnection(Connection DBconn){
try {
if(DBconn!=null && (!DBconn.isClosed())){
DBconn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void CloseResult(ResultSet res){
if(res!=null){
try {
res.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
res=null;
}
}
public static void ClosePreparedStatement (PreparedStatement pastment){
if(pastment!=null){
try {
pastment.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pastment=null;
}
}
}
错误提示是!数据库是SQL2005不是企业版`
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlsever://localhost:1433/BaseDao
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at ConnectionManagerDB.padsment(ConnectionManagerDB.java:40)
at Test.main(Test.java:18)
添加结果是null
- -没人帮下我吗!大哥大姐!我很纠结额你让我叫什么都行!能帮我解决下吗!一下午 了~我是不折不扣的菜鸟额!
public class Test {
public Test() {
// TODO Auto-generated constructor stub
}
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
ConnectionManagerDB.padsment();
}
} 展开
5个回答
展开全部
sun.jdbc.odbc.JdbcOdbcDriver是ODBC桥驱动
而你的连接字符串jdbc:microsoft:sqlsever://localhost:1433/BaseDao是使用的JDBC字符串
更改建议,1、将字符串改为ODBC字符串:jdbc:odbc:ODBC数据源名称
2、或者导入ms server的jar包这个包网上到处都是的(注意,你的字符写的也不对jdbc:microsoft:sqlserver://localhost:1433;databasename = BaseDao)
而你的连接字符串jdbc:microsoft:sqlsever://localhost:1433/BaseDao是使用的JDBC字符串
更改建议,1、将字符串改为ODBC字符串:jdbc:odbc:ODBC数据源名称
2、或者导入ms server的jar包这个包网上到处都是的(注意,你的字符写的也不对jdbc:microsoft:sqlserver://localhost:1433;databasename = BaseDao)
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
确定是SQL2005数据库,
你的驱动名和URL改成下面试试:
driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;databaseName=BaseDao
如果不行的话,换个驱动包试试,去Microsoft官网去下驱动包
http://search.microsoft.com/results.aspx?mkt=zh-cn&q=SQL+Server+JDBC+Driver&form=MSSBMNS
你的驱动名和URL改成下面试试:
driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;databaseName=BaseDao
如果不行的话,换个驱动包试试,去Microsoft官网去下驱动包
http://search.microsoft.com/results.aspx?mkt=zh-cn&q=SQL+Server+JDBC+Driver&form=MSSBMNS
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
哎。。。你的数据库是不是sqlserver 2000的?
如果是2005的话。private String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url="jdbc:sqlserver://localhost:1989;DatabaseName=company";
private String uid="sa";
private String pwd="sa";
protected Connection con=null;
protected PreparedStatement pstmt=null;
protected ResultSet rst=null;
/**
* 得到数据库连接
* @return con
*/
public Connection GetCon()
{
try
{
Class.forName(driver);
con=DriverManager.getConnection(url,uid,pwd);
}
catch (Exception e)
{
e.printStackTrace();
}
return con;
}
如果是2005的话。private String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url="jdbc:sqlserver://localhost:1989;DatabaseName=company";
private String uid="sa";
private String pwd="sa";
protected Connection con=null;
protected PreparedStatement pstmt=null;
protected ResultSet rst=null;
/**
* 得到数据库连接
* @return con
*/
public Connection GetCon()
{
try
{
Class.forName(driver);
con=DriverManager.getConnection(url,uid,pwd);
}
catch (Exception e)
{
e.printStackTrace();
}
return con;
}
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
你的驱动字符串写成SQL 2000的了.
换成2005.
com.microsoft.sqlserver.jdbc.SQLServerDriver
换成2005.
com.microsoft.sqlserver.jdbc.SQLServerDriver
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询