jsp mysql update_jsp+mysql开发最简单的商品增删改查的实例

package com.phome.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class DbHelper {

static{

//1.加载驱动

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public Connection getConnect() throws SQLException

{

//2.建立连接

String url="jdbc:mysql://localhost:3306/mydb?characterEncoding=UTF-8";

Connection conn=DriverManager.getConnection(url, "root", "root");

return conn;

}

public int executeUpdate(String sql,Object[] args)

{

Connection conn=null;

PreparedStatement pst=null;

try {

conn=this.getConnect();

pst=conn.prepareStatement(sql);

if (args!=null)

{

for (int i = 0; i < args.length; i++) {

pst.setObject(i+1, args[i]);

}

}

int rows=pst.executeUpdate();

return rows;

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally{

try {

if (pst!=null)

{

pst.close();

}

if (conn!=null && !conn.isClosed())

{

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return -1;

}

public static void main(String[] args) {

Connection conn=null;

PreparedStatement pst=null;

try {

//1.加载驱动

Class.forName("com.mysql.jdbc.Driver");

//2.建立连接

String url="jdbc:mysql://localhost:3306/mydb?characterEncoding=UTF-8";

conn=DriverManager.getConnection(url, "root", "root");

//3.执行sql语句

String sql="insert into product values (default,?,?,?)";

pst=conn.prepareStatement(sql);

pst.setObject(1, "c++新品");

pst.setObject(2, 59.3);

pst.setString(3, "/images/indexbanner_02.gif");

int result=pst.executeUpdate();

//4.处理执行结果

if (result>0)

{

System.out.println("插入数据库成功");

}

else

{

System.out.println("插入数据库失败");

}

//5.关闭

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally{

try {

if (pst!=null)

{

pst.close();

}

if (conn!=null && !conn.isClosed())

{

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}