问题在哪呀
package com.llz.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
public class JdbcUtil {
private static String driver;
private static String JdbcUrl;
private static String userName;
private static String userPassword ;
static {
ResourceBundle bundle = ResourceBundle.getBundle("Jdbc");
driver = bundle.getString("driver");
JdbcUrl = bundle.getString("JdbcUrl");
userName = bundle.getString("userName");
userPassword = bundle.getString("userPassword");
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//获取connection对象
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(JdbcUrl, userName, userPassword);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return conn;
}
//关闭
public static void closeState(Statement state){
if(state!=null){
try {
state.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
public static void closeConn(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
package com.llz.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
class JdbcTest{
public void test(int id,String address,int amount){
Connection conn = null;
Statement state = null;
try{
conn = JdbcUtil.getConnection();
String sql = "insert into goodcount values('"+id+"','"+address+"','"+amount+"')";
state = conn.createStatement();
int flag = state.executeUpdate(sql);
System.out.println(flag);
}catch (Exception e){
e.printStackTrace();
}finally {
JdbcUtil.closeState(state);
JdbcUtil.closeConn(conn);
}
}
public void updateTest(int id,String address,int amount){
Connection conn = null;
Statement state = null;
try{
conn=JdbcUtil.getConnection();
String sql = "update goodcount set id = '"+id+"',address='"+address+"' where amount="+amount+"";
state = conn.createStatement();
int flag = state.executeUpdate(sql);
System.out.println(flag);
}catch (Exception e){
e.printStackTrace();
}finally {
JdbcUtil.closeConn(conn);
JdbcUtil.closeState(state);
}
}
}
public class StatementTest {
public static void main(String[] args) {
JdbcTest jt = new JdbcTest();
jt.test(6,"重庆",5);
//jt.updateTest(8,"湖南",5);
}
}
driver = com.mysql.jdbc.Driver
JdbcUrl = jdbc:mysql://localhost:3306/good?useUnicode=true&characterEncoding=utf-8
userName = root
userPassword =123456