jsp新闻网站 新闻发布 新闻修改删除等操作

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package Mybean; import java.sql.*; /** * * @author hejie */ public class dbcon { String user="root"; String password="123"; String driverName="com.mysql.jdbc.Driver"; String connectURL="jdbc:mysql://localhost:3306/news"; Connection conn=null; Statement stmt=null; ResultSet rs=null; public dbcon() { try{ Class.forName(driverName); conn=DriverManager.getConnection(connectURL,user,password); conn.setAutoCommit(true); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); System.out.println("数据库连接成功"); } catch(Exception e) { System.out.println("数据库连接错误"+e.getMessage()); } } public ResultSet executeQuery(String sql) { try{ rs=stmt.executeQuery(sql); } catch(SQLException ex) { System.out.println("数据库查询错误"+ex.getMessage()); } return rs; } public int executeUpdate(String sql) { try{ int i=stmt.executeUpdate(sql); return i; } catch(SQLException ex) { System.out.println("执行更新错误："+ex.getMessage()); return -1; } } public Connection getcon() { return conn; } public void closedb(){ try { conn.close(); stmt.close(); System.out.println("数据库关闭成功"); } catch (Exception e) { e.printStackTrace(); System.out.println("数据库关闭失败"); } } }