Question

JAVA如何向SQL数据库中插入记录

Answer 1

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)
自己配一下　
貌似有点麻烦
以后项目方便

Answer 2

对了　桥连是需要陪数据源的
数据源　aaa
算了　还是用楼上的吧

Answer 3

写错了.... 重写...