【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,ContactBean.java,希望对大家有所帮助!
package jspdev;
import java.
sql.*;
public class ContactBean
{
private Connection con;
//初始化连接。
public ContactBean()
{
String CLASSFORNAME="sun.jdbc.odbc.JdbcOdbcDriver";
String SERVANDDB="jdbc:odbc:student";
String USER="sa";
String PWD="sa";
try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
}
//向数据库中添加信息
public void addContact()throws Exception
{
try
{
PreparedStatement pstmt=con.prepareStatement("insert into student values(?,?,?,?,?)");
pstmt.setString(1,"004");
pstmt.setString(2,"Mary");
pstmt.setString(3,"girl");
pstmt.setString(4,"3年级");
pstmt.setString(5,"复旦大学");
pstmt.execute();
// con.close();
}
catch(Exception e)
{
e.printStackTrace();
throw e;
}
}
//
查询数据库
public ResultSet getContact(String sname)
{
try
{
Statement stm=con.createStatement();
ResultSet result=stm.executeQuery("select * from student where sname='"+sname+"'");
return result;
}
catch(Exception e)
{
}
return null;
}
}