<%@ page contentType="text/html;charset=GB2312" language="java" import="java.sql.*,java.util.*;"%>
<html>
<head>
<title>投票列表</title>
</head>
<%! String url,sql;%>
<%! Connection conn;%>
<%! ResultSet rs;%>
<%! Statement stmt;%>
<%! int i;%>
<body bgcolor="#ffffff">
<div align="center"><font color="#000000" size="5">投票列表</font></div>
<table width="80%" border="1" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width=13% align=center>题目</td>
<td width=13% align=center>内容</td>
<td width=12% align=center>A</td>
<td width=12% align=center>B</td>
<td width=12% align=center>C</td>
<td width=12% align=center>D</td>
<td width=11% align=center>编辑</td>
<td width=11% align=center>删除</td>
</tr>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
url="jdbc:mysql://localhost:3306;DatabaseName=votemanage";
conn=DriverManager.getConnection(url,"root","123");
stmt=conn.createStatement();
sql="select * from vote";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td width=13% align=center><%=rs.getObject(1)%></td>
<td width=13% align=center><%=rs.getObject(2)%></td>
<td width=12% align=center><%=rs.getObject(3)%></td>
<td width=12% align=center><%=rs.getObject(4)%></td>
<td width=12% align=center><%=rs.getObject(5)%></td>
<td width=12% align=center><%=rs.getObject(6)%></td>
<td width=11% align=center><a hrefa="change.jsp?name=<%=rs.getObject(1) %>">
编辑</a></td>
<td width=11% align=center><a hrefa="del.jsp?name=<%=rs.getObject(1) %>">
删除</a></td></tr>
<%
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.println(e);}
%>
</table>
<div align="center"><a href="inser.jsp">输入界面</a></div>
</body>
</html>以上是源码,有异常抛出,求大神解决!
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
怎么办?困扰小弟良久,哎,学艺不精!
<html>
<head>
<title>投票列表</title>
</head>
<%! String url,sql;%>
<%! Connection conn;%>
<%! ResultSet rs;%>
<%! Statement stmt;%>
<%! int i;%>
<body bgcolor="#ffffff">
<div align="center"><font color="#000000" size="5">投票列表</font></div>
<table width="80%" border="1" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width=13% align=center>题目</td>
<td width=13% align=center>内容</td>
<td width=12% align=center>A</td>
<td width=12% align=center>B</td>
<td width=12% align=center>C</td>
<td width=12% align=center>D</td>
<td width=11% align=center>编辑</td>
<td width=11% align=center>删除</td>
</tr>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
url="jdbc:mysql://localhost:3306;DatabaseName=votemanage";
conn=DriverManager.getConnection(url,"root","123");
stmt=conn.createStatement();
sql="select * from vote";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td width=13% align=center><%=rs.getObject(1)%></td>
<td width=13% align=center><%=rs.getObject(2)%></td>
<td width=12% align=center><%=rs.getObject(3)%></td>
<td width=12% align=center><%=rs.getObject(4)%></td>
<td width=12% align=center><%=rs.getObject(5)%></td>
<td width=12% align=center><%=rs.getObject(6)%></td>
<td width=11% align=center><a hrefa="change.jsp?name=<%=rs.getObject(1) %>">
编辑</a></td>
<td width=11% align=center><a hrefa="del.jsp?name=<%=rs.getObject(1) %>">
删除</a></td></tr>
<%
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.println(e);}
%>
</table>
<div align="center"><a href="inser.jsp">输入界面</a></div>
</body>
</html>以上是源码,有异常抛出,求大神解决!
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
怎么办?困扰小弟良久,哎,学艺不精!
<%@ page contentType="text/html;charset=GB2312" language="java" import="java.sql.*;java.util.*;com.mysql.jdbc.Driver;"%>
怎么加?我不是做项目,只是一个简单的jsp页面
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DButil { /*
* 连接mysql数据库,要先把mysql的jdbc驱动放到工程的WEB-INF/lib包里面。
*/
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost/smslib", "smslib", "smslib");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
} /*
* 这里使用PreparedStatement,因为效率高、安全性高(可以防sql注入)。
*/
public static PreparedStatement preStatement(Connection conn, String sql) {
PreparedStatement ps = null;
try {
// 参照JDK API中的Connection类
ps = conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return ps;
} public static void close(Connection conn) {
try {
conn.close();
conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
} public static void close(Statement stmt) {
try {
stmt.close();
stmt = null;
} catch (SQLException e) {
e.printStackTrace();
}
} public static void close(ResultSet rs) {
try {
rs.close();
rs = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}