转贴;
首先,你要去www.mysql.org下载mysql的JDBC驱动程序,然后再写链接数据库的类!连接数据库的代码如下:
package note;
import java.sql.*;public class Sql{
String sDBDriver="org.gjt.mm.mysql.Driver";
String sConnStr="jdbc:mysql://localhost:3306/note?user=skyyjl&password=abc";
Connection conn=null;
ResultSet rs=null;
public Sql(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("sqlbean():"+e.getMessage());
}
}
public void update(String sql)throws Exception{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
stmt.close();
}
catch(SQLException ex){
System.err.println("sqlbean.executeUpdate:"+ex.getMessage());
}
} public ResultSet query(String sql)throws Exception{
rs=null;
try{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
conn.close();
stmt.close();
}
catch(SQLException ex){
System.err.println("sqlbean.executeQuery:"+ex.getMessage());
}
return rs;
}
}
首先,你要去www.mysql.org下载mysql的JDBC驱动程序,然后再写链接数据库的类!连接数据库的代码如下:
package note;
import java.sql.*;public class Sql{
String sDBDriver="org.gjt.mm.mysql.Driver";
String sConnStr="jdbc:mysql://localhost:3306/note?user=skyyjl&password=abc";
Connection conn=null;
ResultSet rs=null;
public Sql(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("sqlbean():"+e.getMessage());
}
}
public void update(String sql)throws Exception{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
stmt.close();
}
catch(SQLException ex){
System.err.println("sqlbean.executeUpdate:"+ex.getMessage());
}
} public ResultSet query(String sql)throws Exception{
rs=null;
try{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
conn.close();
stmt.close();
}
catch(SQLException ex){
System.err.println("sqlbean.executeQuery:"+ex.getMessage());
}
return rs;
}
}
解决方案 »
- input焦点(80分)
- JAVASCRIPT获得SERVLET传递过来的字符串的问题
- tomcat 连接池的一个剧奇怪的问题!!
- 如何防止直接访问jsp文件
- 如何制作一个可自动带出相对应资料的文本框
- 新手,我想从MYSQL数据库中读出内容,请帮忙查看,下面的语句哪有错误?
- SecurityError: Error #2123: 安全沙箱冲突
- web系统实现短信群发
- 请高手们指点一下,jsp里的sql语句里,如果要引用变量,那些引号的用法,我被几个sql语句搞懵了
- 大神们求解答
- 关于servlet和jsp通讯的问题,请大家帮忙,在线等待!
- jsp与SQL SERVER 2000O数据库的问题????
<%@ page language="java" import="java.sql.*" %><%
Driver DriverRecordset1 = (Driver)Class.forName("org.gjt.mm.mysql.Driver).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM tblb_battery ORDER BY fB_BaCode ASC");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
Recordset1.next();
int intRowCount=Recordset1.getInt(1);
Recordset1.close();
to楼主:其实不必在classpath中设置该驱动的,因为用tomcat你可以把这个jar文件拷贝到工程的/WEB-INF/lib下,重新启动tomcat,就可以了。
我连接的代码如下:
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();//这句话特别注意
}catch(Exception ex){
log.log( ex.toString() );
}
try{
String url ="jdbc:mysql://localhost/test?user=root";//这句话特别注意
Connection conn= DriverManager.getConnection(url);
conn.close();
}catch(Exception ex){
log.log( ex.toString() );
}
改成<%@page language="java" import="java.sql.*"%>
就可以了只要你数据库没设错就没问题
.;C:\J2SDK1.4.1_01\lib\tools.jar;C:\J2SDK1.4.1_01\lib\dt.jar;D:\mysql-connector-java-3.0.8-stable就可以了,还是要感谢各位。