import java.sql.*;
import java.io.*;
public class test2 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/forStudy?user=root&password=12526";
Connection con = null;
Statement st = null;
PreparedStatement pstmt = null;
InputStream fin = null;
// String sql1 = "update STUDENT set name = '张三' WHERE ID =201;";
// String sql2 = "INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (202,'刘六', '男','江苏苏州');";
// String sql3 = "DELETE FROM STUDENT WHERE ID =202;";
// String sql4 = "select * from student;";
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url);
st = con.createStatement();
// st.execute(sql1);
// System.out.println("修改操作完毕");
// st.execute(sql2);
// System.out.println("数据库操作完毕");
//批处理
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (201,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (202,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (203,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (204,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (205,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (206,'刘六', '男','杭州')");
st.executeBatch();
//传入照片;
File file1 = new File(
"C:\\Users\\pc\\Desktop\\我的照片.jpg");
pstmt = con.prepareStatement("INSERT INTO stu VALUES(?, ?, ?)");
int length = (int)file1.length();
try {
fin = new FileInputStream(file1);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = con.prepareStatement("INSERT INTO stu VALUES(?, ?, ?)");
pstmt.setInt(1, 7);
pstmt.setString(2, "我的照片");
pstmt.setBinaryStream(3, fin, length);
pstmt.executeUpdate();
pstmt.clearParameters();
try {
fin.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt.close();
System.out.println("图片添加操作完毕");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
import java.io.*;
public class test2 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/forStudy?user=root&password=12526";
Connection con = null;
Statement st = null;
PreparedStatement pstmt = null;
InputStream fin = null;
// String sql1 = "update STUDENT set name = '张三' WHERE ID =201;";
// String sql2 = "INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (202,'刘六', '男','江苏苏州');";
// String sql3 = "DELETE FROM STUDENT WHERE ID =202;";
// String sql4 = "select * from student;";
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url);
st = con.createStatement();
// st.execute(sql1);
// System.out.println("修改操作完毕");
// st.execute(sql2);
// System.out.println("数据库操作完毕");
//批处理
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (201,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (202,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (203,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (204,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (205,'刘六', '男','杭州')");
st.addBatch("INSERT INTO STUDENT (ID,NAME, SEX, ADDRESS)VALUES (206,'刘六', '男','杭州')");
st.executeBatch();
//传入照片;
File file1 = new File(
"C:\\Users\\pc\\Desktop\\我的照片.jpg");
pstmt = con.prepareStatement("INSERT INTO stu VALUES(?, ?, ?)");
int length = (int)file1.length();
try {
fin = new FileInputStream(file1);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt = con.prepareStatement("INSERT INTO stu VALUES(?, ?, ?)");
pstmt.setInt(1, 7);
pstmt.setString(2, "我的照片");
pstmt.setBinaryStream(3, fin, length);
pstmt.executeUpdate();
pstmt.clearParameters();
try {
fin.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pstmt.close();
System.out.println("图片添加操作完毕");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}