java 操作数据库通用类 最近学习java,连接sql server 2008成功了,能够写入数据,读取数据,但是每次都要填写帐号,和密码,很烦人,求操作数据库通用类 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ? Java操作数据库最简单了,JDBC,JDO,JPA啥的,一把一把的。 /** * database DEFAULT CHARACTER SET utf8 * */public class JdbcUtil { private static final String url = "jdbc:mysql://localhost:3306/dbdemo?useUnicode=true&characterEncoding=UTF-8"; private static final String user = "root"; private static final String password = "sa"; private static ThreadLocal<Connection> connectionContainer = new ThreadLocal<Connection>(); /** * 注册 * * @throws ClassNotFoundException * @throws SQLException */ public static Connection register() { Connection connection = connectionContainer.get(); try { if (connection == null) { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } connection = DriverManager.getConnection(url, user, password); } connectionContainer.set(connection); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; } public static void freeResource(Statement statement, ResultSet rs) { try { if (rs != null) { rs.close(); } if (statement != null) { statement.close(); } Connection connection = connectionContainer.get(); if (connection != null) { connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { connectionContainer.remove(); } }} 你是想以对象的形势来操作数据库?引入Hibernate就解决了啊 我现在已经这样做了,如何用数据库的事物,存储过程等,谁有封装好的通用类,请分享一下,谢谢那就直接上hibernate把 不一定要用hibernate,spring jdbc也可以,思想就是spring aop切入,事务支持,连接池获取连接。在切入点之前开启事务,执行完事务提交 两个问题 怎么把基本类里的变量获取到servlet里 我想做个调查,有关报表? JTable如何合并单元格行 怎样改变鼠标为自定义图片 JAVA加密问题 怎么样学习java?,java能开发什么?? 郁闷中,我的程序到底怎么啦?求大虾帮我看看 从1~9中任选四个整数,如何用加减乘除,括号,求24点的游戏怎么用Java语言编啊? 有关JNDI的问题 关于java并行编程? 多线程? DOS下运行javac 出现乱码 还有声音,在线等
/**
* database DEFAULT CHARACTER SET utf8
*
*/public class JdbcUtil { private static final String url = "jdbc:mysql://localhost:3306/dbdemo?useUnicode=true&characterEncoding=UTF-8";
private static final String user = "root";
private static final String password = "sa"; private static ThreadLocal<Connection> connectionContainer = new ThreadLocal<Connection>(); /**
* 注册
*
* @throws ClassNotFoundException
* @throws SQLException
*/
public static Connection register() {
Connection connection = connectionContainer.get();
try {
if (connection == null) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
connection = DriverManager.getConnection(url, user, password);
}
connectionContainer.set(connection);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
} public static void freeResource(Statement statement, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (statement != null) {
statement.close();
}
Connection connection = connectionContainer.get();
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
connectionContainer.remove();
}
}
}
我现在已经这样做了,如何用数据库的事物,存储过程等,谁有封装好的通用类,请分享一下,谢谢
那就直接上hibernate把