我用的JDK是j2sdk-1_4_1_07-windows-i586.exe
TOMCAT是jakarta-tomcat-4.1.31.exe
MYSQL是mysql-4.1.15-win32
JDBC是mysql-connector-java-3.1.11
我已经装好了JDK,TOMCAT,都可以用,用http://localhost:8080/index.jsp有欢迎界面,JDK,TOMCAT是OK的,MYSQL也装好,可以导入数据,请问怎么搞JDBC驱动,JSP怎么连数据库还有请问怎么给分,我有多少原始分
TOMCAT是jakarta-tomcat-4.1.31.exe
MYSQL是mysql-4.1.15-win32
JDBC是mysql-connector-java-3.1.11
我已经装好了JDK,TOMCAT,都可以用,用http://localhost:8080/index.jsp有欢迎界面,JDK,TOMCAT是OK的,MYSQL也装好,可以导入数据,请问怎么搞JDBC驱动,JSP怎么连数据库还有请问怎么给分,我有多少原始分
2、将他拷贝到tomcat的common/lib目录下;
3、测试是否连接正常;将如下代码保存成test.jsp至tomcat的webapps/root目录下。:
<%@ page contentType="text/html;charset=gb2312" %>
<%
java.sql.Connection conn;
java.lang.String strConn;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
%>
4、如果运行以后,出现空白页面,即表示正确。
import java.sql.*;
import com.microsoft.*;
public class DBdr { public DBdr() {
}
public Connection getConnection()
{ try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException ex1) {
ex1.printStackTrace();
}
Connection con = null;
try {
con = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dabinglian","sa","sa");
} catch (SQLException ex) {
ex.printStackTrace();
}
return con;
}
public ResultSet getRS(Connection con,String sql)
{
ResultSet rs = null;
try {
Statement stat = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stat.executeQuery(sql);
} catch (SQLException ex) {
ex.printStackTrace();
}
return rs;
}
public int getST(Connection con,String sql) throws SQLException {
Statement stat=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
int effectRow = stat.executeUpdate(sql);
return effectRow;
}这是我写的,以前用mysql时也是这么用的
你用的话,只要改一下,url password username forName 里的驱动你换成Mysql就可以了
呵呵 很久没用mysql了 你试一下
http://www.blogjava.net/rickhunter/category/3664.html