import
java.sql.
*
;
import java.util. * ;
import java.io. * ;
import java.sql. * ;
public class mysql
... {
Connection conn;
String driver;
String url;
String user;
String pwd;
public mysql()
...{
driver = "com.mysql.jdbc.Driver";;
url="jdbc:mysql://localhost:3306/test";
user = "root";
pwd = "123+-*/";
init();
}
public void init()
...{
try...{
Class.forName(driver);
System.out.println("driver is ok");
conn = DriverManager.
getConnection(url,user,pwd);
System.out.println("conection is ok");
}catch(Exception e)
...{
e.printStackTrace();
}
}
public static void main(String args [])
...{
new mysql();
}
}
import java.util. * ;
import java.io. * ;
import java.sql. * ;
public class mysql
... {
Connection conn;
String driver;
String url;
String user;
String pwd;
public mysql()
...{
driver = "com.mysql.jdbc.Driver";;
url="jdbc:mysql://localhost:3306/test";
user = "root";
pwd = "123+-*/";
init();
}
public void init()
...{
try...{
Class.forName(driver);
System.out.println("driver is ok");
conn = DriverManager.
getConnection(url,user,pwd);
System.out.println("conection is ok");
}catch(Exception e)
...{
e.printStackTrace();
}
}
public static void main(String args [])
...{
new mysql();
}
}
<%
@ page contentType
=
"
text/html;charset=gb2312
"
%>
<% @ page import = " java.sql.* " %>
< html >
< body >
<% Class.forName( " com.mysql.jdbc.Driver " );
String url = " jdbc:mysql://localhost:3306/mysql " ;
String user = " root " ;
String password = " 123+-*/ " ; // sa的登陆密码
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = " select * from user " ;
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) ... {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%} %>
<% out.print( " 数据库操作成功,恭喜你 " ); %>
<% rs.close();
stmt.close();
conn.close();
%>
</ body >
</ html >
<% @ page import = " java.sql.* " %>
< html >
< body >
<% Class.forName( " com.mysql.jdbc.Driver " );
String url = " jdbc:mysql://localhost:3306/mysql " ;
String user = " root " ;
String password = " 123+-*/ " ; // sa的登陆密码
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = " select * from user " ;
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) ... {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%} %>
<% out.print( " 数据库操作成功,恭喜你 " ); %>
<% rs.close();
stmt.close();
conn.close();
%>
</ body >
</ html >