一个SQL的问题,急,在线等!!!

Question

哪位大虾能给一段具体点的向数据库添加记录的JAVA代码?

Answer 1

网上很多啊，一搜便知，GOOD LUCK

Answer 2

try{
             db appeddb=new db();
             appeddb.getConnection();
             ResultSet appedRes=appeddb.executeQuery("insert into Tstaff(YGID,YGName,YGSex,YGBirth,YGWage,YGMemo) values("+strID+",'"+strName+"','"+strSex+"','"+strBirth+"','"+strWage+"','"+strMemo+"');");
             JOptionPane.showMessageDialog(f,"插入成功");
             f.dispose();
                 }catch(Exception e){e.printStackTrace();}
db 文件
package myWager;import java.sql.*;
import java.util.*;public class db {
    private ArrayList books;    private String dbUrl = "jdbc:jtds:sqlserver://localhost:1433;DatabaseName=Mydatabase";    private String dbUser = "sa";    private String dbPwd = "123";    private Connection conn;    private Statement stmt;    private ResultSet rs;    public db() throws Exception 
{
        Class.forName("net.sourceforge.jtds.jdbc.Driver");
    }    public Connection getConnection() throws Exception 
{
        return DriverManager.getConnection(dbUrl, dbUser, dbPwd);
    }    public ResultSet executeQuery(String sql)
    {
        try {
            conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                    ResultSet.CONCUR_UPDATABLE);
            rs = stmt.executeQuery(sql);
        } catch (SQLException ex) {
            System.err.println("sql_data.executeQuery:" + ex.getMessage());
        }
        return rs;
    }    public void executeUpdate(String sql) 
    {
        try {
            conn = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (SQLException ex) {
            System.err.println("aq.executeQuery: " + ex.getMessage());
        }
    }    public void executeDelete(String sql) 
    {
        try {
            conn = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (SQLException ex) {
            System.err.println("sql_data.executeDelete:" + ex.getMessage());
        }
    }    public void closeConnection() 
    {
        try {
            if (conn != null)
                conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }    public void closeStmt() 
    {
        try {
            if (stmt != null)
                stmt.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }    public void closeResultSet()
    {
        try {
            if (rs != null)
                rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Answer 3

Class.forName("com.mysql.jdbc.Driver").newInstance(); 
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/toy?user=&password=&useUnicode=true&characterEncoding=GB2312");
      stmt=con.createStatement();
     String upd="insert into supplier(s_hrand,s_com,s_tel,c_mail,s_agency,s_addr,s_rate) values('"+hrand+"','"+com+"','"+tel+"','"+mail+"','"+agency+"','"+addr+"','"+rate+"')";
 stmt.executeUpdate(upd);

Answer 4

stmt应该定义成什么?我是新手,不好意思