怎么把一行数据添加到数据库中?
本人想把某人的姓名,电话,QQ,Email,地址,备注加到数据库的电话簿表中
编写程序如下:
String mxingming=jxingming.getText();
String mdianhua=jdianhua.getText();
String memail=jemail.getText();
String mqq=jqq.getText();
String mdizhi=jdizhi.getText();
String mbeizhu=jbeizhu.getText();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }
catch (ClassNotFoundException ee) {
ee.printStackTrace();
}
String url = "jdbc:sqlserver://10.1.213.53:1433;DatabaseName=通讯录";
String user = "book";
String password = "book";
try {
Connection cnn = DriverManager.getConnection(url,user,password);
sql="insert into telephonedirectory values ('"+mxingming+"','"+mdianhua+"','"+mqq+"','"+memail+"','"+dizhi+"','"+beizhu+"')";
Statement st = cnn.createStatement();
int rs = st.executeUpdate( sql );
if(rs>0)
//判断如果i小于0,则说明添加成功,返回相应的提示信息。
JOptionPane.showMessageDialog(null,"添加成功!");
else
//否则的话提示”添加失败“
JOptionPane.showMessageDialog(null,"添加失败!");
st.close();
cnn.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
补充:本人不知错误在哪里,希望高人指点一下。感激不尽!