UC知道java数据库操作
来源：百度知道 编辑：UC知道 时间：2024/05/14 13:00:55
连接语句写好了
怎么增加message表中的数据
public class messageBean
{
private static Statement sta;
private final static String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MessageBoard";
private final static String dbUSR="sa";
private final static String dbPSW="21259520q";
private Connection con=null;
private String sqlStr=null;
private ResultSet rs=null;
//连接数据库
public void connMsg()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(dbURL,dbUSR,dbPSW);
sta=con.createStatement();
}
catch(Exception e)
{
}
}
//关闭数据库
public void closeMsg()
{
try
{
con.close();
sta.close();
}
catch(Exception e)
{
}
}
//增加数据
怎么增加message表中的数据
public class messageBean
{
private static Statement sta;
private final static String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MessageBoard";
private final static String dbUSR="sa";
private final static String dbPSW="21259520q";
private Connection con=null;
private String sqlStr=null;
private ResultSet rs=null;
//连接数据库
public void connMsg()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(dbURL,dbUSR,dbPSW);
sta=con.createStatement();
}
catch(Exception e)
{
}
}
//关闭数据库
public void closeMsg()
{
try
{
con.close();
sta.close();
}
catch(Exception e)
{
}
}
//增加数据
String sql = "insert into message(content,ip) values('"+neirong+"','"+usrlp+"')";
connMsg();
if(sta!=null){
sta.executeUpdate(sql);
}
closeMsg();
public void addMsg(String sql)
{ messageBean T=new messageBean();
T.connMsg();
try
{
sta = conn.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql);
sta.execute("insert into message(content,ip) values('neirong','usrIp')")
}
catch(SQLException ex)
{
System.out.println("Update");
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
connMsg();
if (sta != null) {
sta.execute("insert into message(content,ip) values('neirong