java代码:
package jdbc;
import java.sql.*;
public class dbConnect {
public static void main(String[] args){
try {
String driver="org.gjt.mm.mysql.Driver";//驱动类
String url="jdbc:mysql://localhost:3306/hai";
String username="root";
String password="1234";
Connection conn=null;
Statement sm=null;
ResultSet rs=null;
Class.forName(driver);
conn=DriverManager.getConnection(url,username,password);
sm=conn.createStatement();
rs=sm.executeQuery("select * from test");
while(rs.next()){
System.out.print(rs.getString("username"));
}
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
JSP页面连接:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<% Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(ClassNotFoundException e){
e.getMessage();
}
try{
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hai","root","1234");
sql=con.createStatement();
rs=sql.executeQuery("select * from test");
out.print("<Table Border>");
out.print("<tr>");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=100>"+"密码");
out.print("</tr>");
while(rs.next()){
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}
catch(Exception e){
e.getMessage();
}
%>
</body>
</html>