整理 javaweb 连接数据库方法

来源：互联网发布：游戏锁定fps软件编辑：程序博客网时间：2024/06/05 02:11

方法1 利用jtds 驱动
\*
common层建立数据库连接工具类 daoutil
连接sqlserver数据库先导入jtds包,

连接方法1：

public class DAOUtil {private final static String DATA_URL = "jdbc:jtds:sqlserver://127.0.0.1:1433/数据库名";//指定连接地址和端口private final static String DATA_PSW = "sa";                                          //登录密码private final static String DATA_UN = "sa";                                           //登录用户名public static Connection getconnection() throws ClassNotFoundException, SQLException{Class.forName("net.sourceforge.jtds.jdbc.Driver");Connection con = DriverManager.getConnection(DATA_URL, DATA_UN, DATA_PSW);con.setAutoCommit(false);return con;}}

连接方法2：（需要在webroot下 meta-inf下配置context.xml 文件,同时在lib目录下需要jtds.jar,如果是连接MySQL数据库
需要mysql-connector-java-5.1.18-bin.jar）

public static Connection getConnection() throws SQLException{Connection con = null;try {Context cntxt = new InitialContext();DataSource ds = (DataSource) cntxt.lookup("java:comp/env/jdbc/数据库名");con = ds.getConnection();con.setAutoCommit(false);} catch (NamingException e) {e.printStackTrace();} return con;}

WebRoot/META-INF/context.xml 配置

<?xml version="1.0" encoding="UTF-8"?><Context><Resource  name="jdbc/woniuoa"       auth="Container"      type="javax.sql.DataSource"      driverClassName ="net.sourceforge.jtds.jdbc.Driver"      url="jdbc:jtds:sqlserver://127.0.0.1:1433/数据库名"     maxActive="1000"    maxIdle="20"    initialSize="50"       timeBetweenEvictionRunsMillis="300000"       minEvictableIdleTimeMillis="1800000"      testWhileIdle="true"    maxWait="5000"     username="sa"      password="sa"  />  </Context>

/*
dao层建立数据库表dao ，在service层调用数据库连接传con参数，dto参数调用具体dao类
*/

public class BaseuserDAO {//查询public Baseuser findByName(Connection con,LoginDto dto) throws SQLException{String sql = "SELECT psw FROM baseuser WHERE uname=?";//这样写可以防止数据注入PreparedStatement ps =con.prepareStatement(sql);ps.setString(1, dto.getName());ResultSet rs = ps.executeQuery();Baseuser bu = new Baseuser();if(rs.next()){bu.setPass(rs.getString("psw"));}return bu;}//增加数据public String addEmp(Connection con,HumanDTO hDto) throws SQLException {System.out.println("addempdao---"+hDto);String sql = "insert into "+"employee (emtime,emname,sex,age,number,campus_id,job_id,emstatus,tel,addr,sosname,sostel,ul_id)"+" values(?,?,?,?,?,?,?,?,?,?,?,?,?)";PreparedStatement ps = con.prepareStatement(sql);ps.setString(1, hDto.getEmTime());ps.setString(2, hDto.getEmName());...ps.setInt(13, hDto.getUlId());ps.executeUpdate();return "ajax 添加成功";}//修改数据public String upDateEmp(Connection con, HumanDTO hDto) throws SQLException {String sql = "update "+"employee=set emtime=?,emname=?,sex=?,age=?,"+"campus_id=?,job_id=?,emstatus=?,tel=?,addr=?,sosname=?,sostel=?"+" where number=?";PreparedStatement ps = con.prepareStatement(sql);ps.setString(1, hDto.getEmTime());...ps.setString(12, hDto.getNumber());System.out.println("number----"+hDto.getNumber());ps.executeUpdate();return "AJAX 修改成功";}}

在业务action层调用service层的方法时，有更新修改删除操作等产生事物要写try{ 没异常Commit} catch
{ 有异常rowback}

0 0