jsp 连接mysql数据库代码

jsp教程连接mysql教程数据库教程代码

//方法一
利用JDK的Javac命令编译DBconn.java形成相应的class文件。
＝》cd   /tomcat4112/webapps教程/examples/WEB-INF/classes/mysqltest/
＝》javac   -g     -verbose   DBconn.java
7。在Tomcat的/webapps/examples/jsp目录下建立Mysqltest.jsp文件。其内容如下：
<%@   page   contentType= "text/html;   charset=gb2312 "   %>
<%@   page   language= "java "   import= "java.sql.* "   %>
<jsp:useBean   id= "DBconn1 "   scope= "page "   class= "Mysqltest.DBconn "   />
<%
ResultSet   RS   =   DBconn1.executeQuery( "SELECT   *   FROM   my_test_table ");
while   (RS.next())   {
out.print( " <h1> "   +   RS.getString( "test_column ")+ " </h1> ");
}
RS.close();

//方法二
//驱动程序名
String driverName="com.mysql.jdbc.Driver";
//数据库用户名
String userName="cl41";
//密码
String userPasswd="123456";
//数据库名
String dbName="db";
//联结字符串

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();

//连接mysql数据库二

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);

//jsp连接mysql数据库三

package   Mysqltest;
import   java.sql.*;
public   class   DBconn
{String   DBDriver= "com.mysql.jdbc.Driver ";
String   ConnStr= "jdbc:mysql://school:3306/my_test ";
String   MyUser= "shimin ";
String   MyPassword= "shimin ";
Connection   conn   =   null;
ResultSet   rs   =   null;
public   DBconn()
{try
{Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException   e)
{System.err.println( "DBconn   ():   "   +   e.getMessage());
}
}
public   ResultSet   executeQuery(String   sql)
{rs   =   null;
try
{conn   =   DriverManager.getConnection(ConnStr,MyUser,MyPassword);
Statement   stmt   =   conn.createStatement();
rs   =   stmt.executeQuery(sql);
}
catch(SQLException   ex)
{System.err.println( "aq.executeQuery: "+ex.getMessage());
}
return   rs;
}
}

补充：Jsp教程,Java基础