谁有JSP链接MYSQL的代码？

Question

听说除此之外 还要下载什么桥接器才能运行吧？

Answer 1

需要MySQL驱动包

<%@ page contenttype="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
string mysqldriver = "org.gjt.mm.mysql.driver";
string url = "jdbc:mysql://localhost/dbname";//数据库连接 dbname是数据库名称
connection conn;
class.forname(mysqldriver);
conn = drivermanager.getconnection( url,"root","");//用户名与密码
if(conn==null){
system.out.println("get conn error");
}
statement stmt=conn.createstatement();
resultset rs=null;
rs=stmt.executequery("select * from news_art");
while(rs.next())
{//循环显示记录
%>
<a href=display.jsp?id=<%=rs.getstring("id")%> target=_blank><%=rs.getstring("title")%></a>(<%=rs.getstring("times")%>)
<%="<br>"%>
<%
}
rs.close();
stmt.close();
conn.close();
%>

Answer 2

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**关于表User的操作
* @author Renny
*/

public class MySQLTest {
private String driverName = "com.mysql.jdbc.Driver";
private String dburl = "jdbc:mysql://localhost:3306/Cardms?user=root&" +
"password=mysql";
private Connection con = null;

public MySQLTest() {
try {
//Class.forName(driverName);
con = DriverManager.getConnection(dburl);
System.out.println("Connect successfully");
} catch(SQLException se) {
se.printStackTrace();
}
catch(Exception e) {
e.printStackTrace();
}
}

public static void main(String[] args) {
MySQLTest test = new MySQLTest();
}
}

如果成功连接则会输出:Connect successfully.

另外,在Java中使用MySQL中的数据库,需要到MySQL的官网下载JDBC的驱动程序,mysql-connector-java-5.1.7-bin.jar