package com.bjsxt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcTest {
//向departments表中添加一条数据
public void insertDepartments(String department_name,int location_id){
Connection conn = null;
Statement state = null;
try {
//驱动注册
Class.forName("com.mysql.jdbc.Driver");
//创建连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjsxt?useUnicode=true&characterEncoding=utf-8","root","123456");
//执行sql
String sql="insert into departments values(default,'"+department_name+"',"+location_id+")";
state = conn.createStatement();
int falg = state.executeUpdate(sql);
System.out.println(falg);
} catch (Exception e) {
e.printStackTrace();
}finally {
if (state !=null){
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
if (conn !=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
JdbcTest test = new JdbcTest();
test.insertDepartments("研发部",8);
}
}
还在报错。
应该如何解决呢
京公网安备 11011402011233号