您好我做了一个名为Test的简单数据库,eclipse与数据库连接成功,但是在eclipse中信息插不进A表中,请大家帮我看一下啦,谢谢!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; import sun.jdbc.odbc.JdbcOdbcDriver; public class DBConnection {
DBConnection db;
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub DBConnection db = new DBConnection();
db.getConn();
//信息插不进A表中
try {
db.getStmt().execute("insert into A values('陈世友','男')");//这里和下面那条语句报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } public Statement getStmt() {
Statement stmt = null;
try {
stmt = getConnDirect().createStatement();//这里也报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return stmt;
} private Connection getConnDirect() {
// TODO Auto-generated method stub
return null;
} public Connection getConn() {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:odbc:Test", "sa", "123");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (conn != null) {
System.out.println("数据库已经连接上");
}
return conn; }
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; import sun.jdbc.odbc.JdbcOdbcDriver; public class DBConnection {
DBConnection db;
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub DBConnection db = new DBConnection();
db.getConn();
//信息插不进A表中
try {
db.getStmt().execute("insert into A values('陈世友','男')");//这里和下面那条语句报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } public Statement getStmt() {
Statement stmt = null;
try {
stmt = getConnDirect().createStatement();//这里也报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} return stmt;
} private Connection getConnDirect() {
// TODO Auto-generated method stub
return null;
} public Connection getConn() {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:odbc:Test", "sa", "123");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (conn != null) {
System.out.println("数据库已经连接上");
}
return conn; }
}
public Statement getStmt() {
Statement stmt = null;
try {
stmt = getConnDirect().createStatement();//这里也报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} 改成
public Statement getStmt(Connection conn) {
Statement stmt = null;
try {
stmt = conn.createStatement();//这里也报错
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} 然后在上面调用的时候也改下db.getStmt(db.getConn())这样应该就没有问题了