jsp 链接数据库报错 请大家帮忙啊 找不到驱动。你检查一下你的驱动放的位置是不是“sun.jdbc.odbc.JdbcOdbcDriver”。是不是在 classpath里。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 to 楼上 数据源我已经添加了。添加的名称就是 happy 能不能用jdbc?用odbc移植性太差了吧,学也要学jdbc啊,现在大部分做项目都用jdbc吧。 1、数据源要在电脑上配置好2、驱动包sun.jdbc.odbc.JdbcOdbcDriver要放到你web工程的lib里面或者在你classpath也可以 哪里有 驱动包sun.jdbc.odbc.JdbcOdbcDriver 呢? 代码我测试过了,没任何问题,那原因应该在环境方面 数据源的配置(用户DSN里添加) 数据库登陆的名和密码试试吧! 老兄 别在JSP中写连接数据库的代码咯 我建议你使用JDBC效力高点给你几个连接不同数据库的方法 :连接mysql 在lib下添加 mysql-connector-java-5.0.6-bin.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil { private static Connection conn=null; private static final String DRIVER= "com.mysql.jdbc.Driver"; private static final String URL= "jdbc:mysql://localhost/test?user=root&password=111111"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { e.printStackTrace(); } } public synchronized static Connection getConn()throws SQLException { return DriverManager.getConnection(URL); } public static void main(String[] args) throws SQLException { String sql="select *from users"; conn=DBUtil.getConn(); Statement sta=conn.createStatement(); ResultSet rs=sta.executeQuery(sql); while(rs.next()){ System.out.println(rs.getString(3)); } } } 连接sql2005 lib下导入sqljdbc.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class SQLDB { private static Connection conn=null; private static final String DRIVER= "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL= "jdbc:sqlserver://localhost:1433;databaseName=test"; private static String ename="sa"; private static String pwd="xu123"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConn()throws SQLException{ return DriverManager.getConnection(URL,ename,pwd); } public static void main(String[] args) throws SQLException { conn=SQLDB.getConn(); System.out.println(conn.toString()); } } oralce10g连接 libclasses12.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class oracleDB { private static Connection conn=null; private static final String DRIVER= "oracle.jdbc.driver.OracleDriver"; private static final String URL= "jdbc:oracle:thin:@localhost:1521:ORCL"; // ORCl:为oracle服务名称 private static String ename="system"; private static String pwd="system"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { // TODO: handle exception } } public static Connection getConn()throws SQLException { return DriverManager.getConnection(URL,ename,pwd); } public static void main(String[] args) throws SQLException { conn=oracleDB.getConn(); System.out.println(conn.toString()); } } assertEquals(0, 0, 0)有啥用? 关于webservice的报java.lang.LinkageError: JAXB 2.0 API。。。 JSP中能用 FusionChart生成折线图,柱状图吗? java 调用 sql server reporting service 登录校验与dwr (ajax) 上传文件时出错了 关于数据库与javamail的问题 怎么打包jsp程序 俺要驱动老大们。。。。。 jsp+mysql的中文显示问题 如果在jsp页面中调用系统快捷键呢? 求一个arraylist的问题,希望高手给予指点
2、驱动包sun.jdbc.odbc.JdbcOdbcDriver要放到你web工程的lib里面或者在你classpath也可以
数据源的配置(用户DSN里添加)
数据库登陆的名和密码试试吧!
连接mysql
在lib下添加 mysql-connector-java-5.0.6-bin.jar
package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; public class DBUtil { private static Connection conn=null;
private static final String DRIVER=
"com.mysql.jdbc.Driver";
private static final String URL=
"jdbc:mysql://localhost/test?user=root&password=111111"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
e.printStackTrace();
}
} public synchronized static Connection getConn()throws SQLException {
return DriverManager.getConnection(URL);
} public static void main(String[] args) throws SQLException {
String sql="select *from users";
conn=DBUtil.getConn();
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(3));
}
}
}
连接sql2005 lib下导入sqljdbc.jar
package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException; public class SQLDB {
private static Connection conn=null;
private static final String DRIVER=
"com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL=
"jdbc:sqlserver://localhost:1433;databaseName=test";
private static String ename="sa";
private static String pwd="xu123"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
e.printStackTrace();
}
} public static Connection getConn()throws SQLException{
return DriverManager.getConnection(URL,ename,pwd);
}
public static void main(String[] args) throws SQLException {
conn=SQLDB.getConn();
System.out.println(conn.toString());
}
} oralce10g连接
libclasses12.jar package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException; public class oracleDB {
private static Connection conn=null;
private static final String DRIVER=
"oracle.jdbc.driver.OracleDriver";
private static final String URL=
"jdbc:oracle:thin:@localhost:1521:ORCL";
// ORCl:为oracle服务名称
private static String ename="system";
private static String pwd="system"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
// TODO: handle exception
}
} public static Connection getConn()throws SQLException {
return DriverManager.getConnection(URL,ename,pwd); }
public static void main(String[] args) throws SQLException {
conn=oracleDB.getConn();
System.out.println(conn.toString());
}
}