public class DBConnection{ //定义驱动信息;
private String connProvider = "org.gjt.mm.mysql.Driver"; //创建连接url
private static String connUrl = "jdbc:mysql://localhost/tend?user=sa&password=admin&useUnicode=true"; //创建Connection
Connection conn=null; //创建Statement
Statement stmt=null; //创建PrepareStatement
PreparedStatement prepstmt=null; //创建一个ResultSet
ResultSet rs=null;
public DBConnection(){
try{
//连接一个数据库
Class.forName(connProvider);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("DBConnection():"+e.getMessage());
}
} //执行select 语句
//返回一个rs记录集。
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(connUrl);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql查询执行出错:"+ex.getMessage());
}
return rs;
} //执行update,insert语句
public void executeUpdate(String sql){
stmt=null;
rs=null;
try{
conn=DriverManager.getConnection(connUrl);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeQuery(sql);
//stmt.close();
//conn.close();
}
catch(SQLException ex)
{
System.err.println("sql更新语句出错"+ex.getMessage()); }
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
} public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}}
private String connProvider = "org.gjt.mm.mysql.Driver"; //创建连接url
private static String connUrl = "jdbc:mysql://localhost/tend?user=sa&password=admin&useUnicode=true"; //创建Connection
Connection conn=null; //创建Statement
Statement stmt=null; //创建PrepareStatement
PreparedStatement prepstmt=null; //创建一个ResultSet
ResultSet rs=null;
public DBConnection(){
try{
//连接一个数据库
Class.forName(connProvider);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("DBConnection():"+e.getMessage());
}
} //执行select 语句
//返回一个rs记录集。
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(connUrl);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql查询执行出错:"+ex.getMessage());
}
return rs;
} //执行update,insert语句
public void executeUpdate(String sql){
stmt=null;
rs=null;
try{
conn=DriverManager.getConnection(connUrl);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeQuery(sql);
//stmt.close();
//conn.close();
}
catch(SQLException ex)
{
System.err.println("sql更新语句出错"+ex.getMessage()); }
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
} public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}}
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
//myDB?数据?名
Connection conn= DriverManager.getConnection(url);
testmysql.jsp如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" //testDB为你的数据库名
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>