81,092
社区成员
发帖
与我相关
我的任务
分享
import java.sql.*;
import java.util.*;
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)
{
e.printStackTrace();
}
}
//关闭数据库
public void closeMsg()
{
try
{
con.close();
sta.close();
}
catch(Exception e)
{
}
}
//增加数据库成员
public void setMsg(String l_name,String l_content,String l_ip)
{
connMsg();
try
{
sqlStr="insert into message (name,content,ip) values('"+l_name+"','"+l_content+"','"+l_ip+"')";
sta.executeUpdate(sqlStr);
closeMsg();
}
catch(Exception e)
{
e.printStackTrace();
closeMsg();
}
}
}