最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

连接MySQl的JavaBean_MySQL

来源:动视网 责编:小采 时间:2020-11-09 17:36:43
文档

连接MySQl的JavaBean_MySQL

连接MySQl的JavaBean_MySQL:package mysql;import java.sql.*;public class MySqlCon{private String DbName = ;private String pass = ;private String url = ;private Connection con = null;private Statement stmt = null;private ResultSet rs = null;public MySqlCon(){}pub
推荐度:
导读连接MySQl的JavaBean_MySQL:package mysql;import java.sql.*;public class MySqlCon{private String DbName = ;private String pass = ;private String url = ;private Connection con = null;private Statement stmt = null;private ResultSet rs = null;public MySqlCon(){}pub


package mysql;

import java.sql.*;

public class MySqlCon
{
private String DbName = "";
private String pass = "";
private String url = "";
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;

public MySqlCon()
{
}

public void setDbName (String name)
{
this.DbName = name;
}
public void setPass (String pass)
{
this.pass = pass;
}

public void BulidCon()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
url ="jdbc:mysql://localhost/"+DbName+"?user=root&password="+pass+"&useUnicode=true&characterEncoding=gb2312";
con= DriverManager.getConnection(url);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch (Exception e)
{
}
}

public ResultSet selectLog(String sql)
{
try
{
BulidCon();
rs = stmt.executeQuery(sql);
}
catch(Exception e)
{
System.out.println(e.toString());
}
return rs;
}

public void updateLog(String sql)
{
try
{
BulidCon();
stmt.executeUpdate(sql);
}
catch (Exception e)
{
}
}

public void close()
{
try
{
con.close();
stmt.close();
}
catch (SQLException e)
{
}
}

}

文档

连接MySQl的JavaBean_MySQL

连接MySQl的JavaBean_MySQL:package mysql;import java.sql.*;public class MySqlCon{private String DbName = ;private String pass = ;private String url = ;private Connection con = null;private Statement stmt = null;private ResultSet rs = null;public MySqlCon(){}pub
推荐度:
标签: 连接 数据库 java
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top