数据库链接的建立
首先应当加载JAVA 2 SDK 中提供的JDBC-ODBC驱动程序，链接ODBC数据库 ，才能进行数据库链接的建立操作。
conn.jsp
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%><%@ 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/zk1011111_db?user=zk1011111&password=t1y1v1n1&useUnicode=true&characterEncoding=gb2312");
sql=con.createStatement();
rs=sql.executeQuery("SELECT name,email FROM t_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>
<% 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/zk1042823_db?user=zk11111&password=t1y1v1n1&useUnicode=true&characterEncoding=gb2312");
sql=con.createStatement();
rs=sql.executeQuery("SELECT name,email FROM t_test");
out.print("");
out.print("");
out.print("");
while(rs.next()){
out.print("");
out.print("");
out.print("");
out.print("");
}
out.print("
| "+"姓名"); out.print(" |
"+"邮件"); out.print(" |
|---|---|
| "+rs.getString(1)+" | "+rs.getString(2)+" |
con.close();
}
catch(Exception e){
e.getMessage();
}
%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%><%@ page import="java.sql.*"%>
<% 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/zk1042823_db?user=zk1042823&password=t1y6v6n0&useUnicode=true&characterEncoding=gb2312");
sql=con.createStatement();
rs=sql.executeQuery("SELECT name,email FROM t_test");
out.print("");
out.print("");
out.print("");
while(rs.next()){
out.print("");
out.print("");
out.print("");
out.print("");
}
out.print("
| "+"姓名"); out.print(" |
"+"邮件"); out.print(" |
|---|---|
| "+rs.getString(1)+" | "+rs.getString(2)+" |
con.close();
}
catch(Exception e){
e.getMessage();
}
%>
<% 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/username_db?user=username&password=userpassword&useUnicode=true&characterEncoding=gb2312");
sql=con.createStatement();
rs=sql.executeQuery("SELECT name,email FROM t_test");
out.print("");
out.print("");
out.print("");
while(rs.next()){
out.print("");
out.print("");
out.print("");
out.print(" ");
}
out.print("
| "+"姓名"); out.print(" |
"+"邮件"); out.print(" |
|---|---|
| "+rs.getString(1)+" | "+rs.getString(2)+" |
con.close();
}
catch(Exception e){
e.getMessage();
}
%>
Leave a comment