JDBC 连接sql server
我的问题是,执行程序会报空指针异常 具体如下
java.lang.NullPointerException
at jdbc.textJdbc.create(textJdbc.java:18)
at jdbc.textJdbc.main(textJdbc.java:30)
我的程序如下
package jdbc;
import java.sql.*;
public class textJdbc {
Connection conn=null;
String connectDB="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=Student";
public void create(UserModel um) throws Exception{
//1: 建立连接
//1.1 装载类
try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//1.2获取与数据库的连接
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=Student","sa","sllf08085991");
System.out.println("数据库连接成功");
String sql="insert into Tb_basic(name,ID,Age) values('"+um.getuName()+"','"+um.getuId()+"','"+um.getuAge()+"')";
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();}
finally{
conn.close();
}
}
public static void main(String []args){
textJdbc tx=new textJdbc();
UserModel um=new UserModel();
um.setuAge("22");
um.setuId("2");
um.setuName("haha");
try {
tx.create(um);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
class UserModel{
String uName,uAge,uId;
public String getuName(){
return uName;
}
public void setuName(String uName){
uName=this.uName;
}
public String getuAge(){
return uAge;
}
public void setuAge(String uAge){
uAge=this.uAge;
}
public String getuId(){
return uId;
}
public void setuId(String uId){
uId=this.uId;
}
}
大神求教!