第1个回答 2013-07-29
package users;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.*;
public class DAO {
Connection conn=null;
PreparedStatement pt=null;
ResultSet rs=null;
int num;
boolean flag=false;
private static final String strcon="sun.jdbc.odbc.JdbcOdbcDriver";
private static final String strman="jdbc:odbc:aaa";
private final String insertSQL="insert into USER values(?,?)";
/**
* 默认构造
*/
public DAO() {
}
/**
* 获得连接
* @return Connection
*/
public Connection Getcon()
{
try {
Class.forName(this.strcon);
}
catch (ClassNotFoundException ex) {
javax.swing.JOptionPane.showMessageDialog(new javax.swing.JButton(),ex.toString());
}
try {
conn = DriverManager.getConnection(this.strman);
}
catch (SQLException ex1) {
javax.swing.JOptionPane.showMessageDialog(new javax.swing.JButton(),ex1.toString());
}
return this.conn;
}
/**
* 添加方法
* @param name String
* @param pass String
* @return boolean
*/
public boolean isinsert(String name,String pass)
{
conn=this.Getcon();
try {
this.pt = conn.prepareStatement(this.insertSQL);
pt.setString(1,name);
pt.setString(2,pass);
num=pt.executeUpdate();
if (num>0)
{
flag=true;
}
}
catch (SQLException ex) {
}
return flag;
}
/**
* 关闭方法
*/
public void CloseDB()
{
if (rs!=null)
{
try {
rs.close();
}
catch (SQLException ex) {
javax.swing.JOptionPane.showMessageDialog(new javax.swing.JButton(),ex.toString());
}
}
if (pt!=null)
{
try {
pt.close();
}
catch (SQLException ex1) {
javax.swing.JOptionPane.showMessageDialog(new javax.swing.JButton(),ex1.toString());
}
}
if (conn!=null)
{
try {
conn.close();
}
catch (SQLException ex2) {
javax.swing.JOptionPane.showMessageDialog(new javax.swing.JButton(),ex2.toString());
}
}
}
}
public static void main(String[] args)
自己配一下
貌似有点麻烦
以后项目方便