67,513
社区成员
发帖
与我相关
我的任务
分享
package uploadPack;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class ItemManager {
public void uploadItemImage(String itemNo,String name){
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
try{
conn=DBHelper.getConnection();
stmt=conn.prepareStatement("INSERT pictures(picture) VALUES(?)");
stmt.setString(1, name);
stmt.executeUpdate();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
DBHelper.close(rs, stmt, conn);
}
}
}
package uploadPack;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBHelper {
//静态代码块来加载驱动
static {
try{
String driverName="com.mysql.jdbc.Driver";
Class.forName(driverName);
}catch(Exception e){
e.printStackTrace();//打印异常输出
}
}
//连接到指定的数据库,三个参数分别是数据库地址,账号,密码
public static Connection getConnection(){
Connection conn=null;
try{
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/Demos", "root", "root");
}catch(Exception e){
e.printStackTrace();
}
return conn;
}
//关闭数据库连接
public static void close(ResultSet rs,Statement stmt,Connection conn){
try{
if(rs!=null)
rs.close();
}catch(Exception ex){
ex.printStackTrace();
}
try{
if(stmt!=null)
stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}
try{
if(conn!=null)
conn.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
}