连接MySQl的JavaBean

最新推荐文章于 2021-03-14 18:01:37 发布

gztoby

最新推荐文章于 2021-03-14 18:01:37 发布

阅读量1.3k

点赞数

分类专栏： -> Java 文章标签： mysql exception string sql java null

本文链接：https://blog.csdn.net/gztoby/article/details/118900

版权

-> Java 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

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)
{
}
}

}

更多资源：
参与论坛讨论: http://www.java-cn.com/forum/index.jsp
更多技术文章: http://www.java-cn.com/technology/index.jsp
JAVA中文站: 我们要做中国最好的JAVA门户网站,记住我们的域名: JAVA-CN.COM | JAVA-CN.NET | JAVA-CN.ORG

本文网址: http://www.java-cn.com/technology/technology_detail.jsp?id=2914
声明: 转载此文章,须在显著位置注明 JAVA中文站的原文网址;
若是本站的转载文章,请标明原文出处,并保留作者信息