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)
{
}
}
} [@more@]
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>