DAO 操作数据库
来源:互联网 发布:淘宝买药货到付款规则 编辑:程序博客网 时间:2024/04/30 08:20
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.resource.cci.ResultSet;
import po.Customer;
public class CustomerDao {
private Connection conn = null;
// 连接数据库
private void initConnection() {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
System.out.println("数据库驱动类没找到");
}
try {
// 建立连接
String serverName = "127.0.0.1";
String portNumber = "1521";
String sid = "oracle";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "scott";
String password = "tiger";
conn = DriverManager.getConnection(url, username, password);
System.out.println("数据库连接成功!");
} catch (SQLException e) {
System.out.println("执行SQL语句异常!");
e.printStackTrace();
}
}
// 插入数据
public boolean insertCustomer(Customer cus) {
String sql = "INSERT INTO T_CUSTOMER(ACCOUNT,PASSWORD,CNAME,CBALANCE)VALUES(1,1,1,1)";
try {
initConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, cus.getAccount());
ps.setString(2, cus.getPassword());
ps.setString(3, cus.getCname());
ps.setDouble(4, cus.getCbalance());
ps.executeUpdate();
return true;
} catch (Exception ex) {
ex.printStackTrace();
} finally {
closeConnection();
}
return false;
}
// 修改数据
public boolean updateCustomer(Customer cus) {
String sql = "UPDATE T_CUSTOMER SET PASSWORD=?,CNAME=?,CBALANCE=? WHERE ACCOUNT=?";
try {
initConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, cus.getPassword());
ps.setString(2, cus.getCname());
ps.setDouble(3, cus.getCbalance());
ps.setString(4, cus.getAccount());
ps.executeUpdate();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
closeConnection();
}
return false;
}
// 查询数据
public Customer getCustomer(String account) {
String sql = "SELECT ACCOUNT,PASSWORD,CNAME,CBALANCE FROM T_CUSTOMER WHERE ACCOUNT=?";
try {
initConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, account);
ResultSet rs = (ResultSet) ps.executeQuery();
if (rs.next()) {
Customer cus = new Customer();
cus.setAccount(rs.getString("ACCOUNT"));
cus.setPassword(rs.getString("PASSWORD"));
cus.setCname(rs.getString("CNAME"));
cus.setCbalance(rs.getDouble("CBALANCE"));
return cus;
}
} catch (Exception ex) {
ex.printStackTrace();
} finally {
closeConnection();
}
return null;
}
// 断开连接
public void closeConnection() {
try {
if (conn != null) {
conn.close();
conn = null;
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
- DAO 操作数据库
- 数据库操作dao文件
- DAO数据库操作
- VC DAO 操作数据库
- Hibernate 数据库操作 DAO 实例
- 通过DAO操作Access数据库
- 连接操作数据库DAO类
- yii AR DAO数据库操作
- dao层数据库查询操作
- Sqlite数据库操作Dao类
- Android数据库操作的操作(SQLiteOpenHelper Dao)
- Yii数据访问对象DAO操作数据库
- spring,hibernate,dao操作数据库模…
- Dao对数据库的操作进行封装
- BaseDB MongoDb dao数据库操作类
- Java_数据库操作对象DAO浅谈;
- PHP Yii使用DAO操作数据库
- Spring使用DAO完成数据库操作
- DNS and BIND (5th Edition)
- convert decimal to binary
- Firewall Fundamentals
- JS中得到C#后台服务器Session的值
- 乒坛名将王楠今日大婚 想要生龙凤胎(图)
- DAO 操作数据库
- Learning PHP and MySQL
- 建议 Suggestions建议 Suggestions
- ajax实例1
- 互联网之父Vint Cerf:互联网的下一个十年
- Agile Software Construction
- ajax实例2
- Computer Security Basics
- 文本输入一个人的学号,当光标离开输入框时,文本框内显示该学号对应的姓名