连接MySQl的JavaBean

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中文站 的原文网址;           若是本站的转载文章,请标明原文出处,并保留作者信息