Question

myeclipse中怎样编写一个完整的数据库插入程序

Answer 1

创建一个类DB 该类负责连接数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class DB {
public static Connection getConnection() throws Exception{
Connection con=null;
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/hibernate","root","root");
return con;
}
public static PreparedStatement prepare(Connection con ,String sql) throws Exception{
PreparedStatement ps=null;
ps=con.prepareStatement(sql);
return ps;
}
}

在创建一个class文件专门进行增删改查
我这里以保存图片为例给你讲解
public class SavePicture{
private static Connection con;
private static PreparedStatement ps;
public void save() throws Exception {
con=DB.getConnection();
String sql="insert into student(name,picture) values (?,?)";
ps=DB.prepare(con, sql);
File f=new File("xxx.jpg");
FileInputStream in= new FileInputStream(f);
ps.setString(1, f.getName());
ps.setBlob(2, in);
ps.executeUpdate();
ps.close();
con.close();
}
}

Answer 2

java向数据库中插入数据，可以使用mysql数据库，使用statement类来操作数据库，示例如下：
Connection conn = null;
Statement st = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//加载驱动类
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://<server_name>:<1433>", "name","pwd");
conn.setAutoCommit(false);
st = conn.createStatement();
// 模拟一个 str[i] = nd.getNodeValue().trim()
String[] str = new String[] { "aaa", "bbb", "ccc", "ddd", "eee","fff" };
String sqlStr = null;
for (int i = 0; i < str.length; i++) {
sqlStr = "INSERT INTO <TABLENAME> (<COLNAME>)VALUES('" + str[i] + "')";//向数据库中插入数据
st.executeUpdate(sqlStr);
}
conn.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {//释放数据库的资源
try {
if (st != null)
st.close();
if(conn != null && !conn.isClosed()){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}