轻松应对JSP连接MySQL数据库问题[2]
第二种方式是由JavaBean实现的:
封装连接器;//导入包导入Java . SQL . *;
//导入数据库操作的类public class dbconn MySQL
/构造方法,初始化{ private Connection conn
//连接对象私有语句stmt
//语句对象privateresultsetters
//结果集对象私有字符串MySqldriver
//MYSQL服务器驱动字符串私有字符串MySqlURL
//MYSQL服务器连接字符串//* * * * * * * * * * * * * * * * * * * * * * * * * * * * *
由org . gjt . mm . MYSQL . driver[/br Dbname、user、pass、port
分别代表MYSQL服务器的地址、
*数据库、用户名、密码、 Port
* * * * * * * * * * * * * * * * * * * * * * * * * * * * */
公共连接GetConntomySQL
(String Server,String DBName,String User Port)
{//MySQL driver MySQL driver = " org . gjt . mm . MySQL . driver ";
mysqurl = " JDBC:MySQL://";
//部分连接字符串try{//完整连接字符串mysqurl
= mysqurl+server+":"+port+"/"+dbname+"?user =
"+user+" & password = "+pass+" & use unicode
= true & character encoding = GB 2312 ";
class . forname(MySQL driver);conn
= driver manager . get connection(MySqlURL);}
catch(exception one){ system . out . println
(“数据库操作出错,请仔细检查”);
//system . err . println(e . getmessage());}返回连接;}
//关闭数据库连接public void Close(){ try {//RS . Close();
//stmt . close();conn . close();} catch(SQLException
SQLException){ SQLException . printstacktrace();}}}
这个文件只实现数据库的连接。接下来写一个测试文件,就是用SQL语句从数据库中查询记录,验证我们的数据库连接是否成功。
Connmysql.jsp文件的源代码如下:
charset = GB 2312 " > charset = GB 2312 " language = " Java " import = " Java . SQL . * " % >
/MySQL服务器的地址字符串dbname = " test
//MySQL数据库字符串user="root "的名称;
//MySQL数据库的登录用户名String pass = " chfanwsp
//MySQL数据库字符串port="3306 "的登录密码;
//SQL Server服务器的端口号,默认为1433 connection
conn = dbconn . getconntomysql
(Server,dbname,user,pass,port);
语句stmt = conn . create Statement
(ResultSet。TYPE_SCROLL_INSENSITIVE,
ResultSet。CONCUR _ READ _ ONLY);
String SQL = " select * from username ";
string SQL 1 = " insert into username(uid,pwd)值
('梦幻岁月','梦幻岁月')";stmt . execute update(SQL 1);
ResultSet RS = stmt . execute query(SQL);while(RS . next())
{ out . print(" username:");out . print(RS . getstring(" uid ")+" password:");
out . println(RS . getstring(" pwd ")+"
");}
//RS . close();//stmt . close();//conn . close();dbconn . close();%>
0条评论