package lch;

import java.sql.*;

public class tianjiaguanliyuan
{
    public static Connection conn;
    public static Statement stmtl;
    public static ResultSet rs=null;
    public static final String ACS_CON_STR="sun.jdbc.odbc.JdbcOdbcDriver";
    public static PreparedStatement ps;

    public static Connection getConnect(String url)
    {
        Connection conn=null;
        try
        {    
            Class.forName(ACS_CON_STR);
            conn=DriverManager.getConnection(url);
            
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return conn;
    }
    
    public static boolean disconnect()
    {
        boolean successed=false;
        try{
            if(conn!=null) conn.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return successed;
    }

    public static void prepareStatement1()
    {
        String sql = "insert into dl values (gg,123)";
        PreparedStatement ps;
        try{
        ps=conn.prepareStatement(sql);
        ps.setString(2,"sql");
        ps.executeUpdate();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        
    }
    public static boolean CloseResltSet()
    {
        boolean successed=false;
        try{
            if(rs!=null) rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return successed;
    }
    public static void main(String[] args)
    {
    //String mm="insert into dl values (gg,123)";
    getConnect("jdbc:odbc:library");
    prepareStatement1();
    }
}

String sql = "insert into dl values (gg,123)";
                PreparedStatement ps;
                try{
                ps=conn.prepareStatement(sql);
                ps.setString(2,"sql");
                ps.executeUpdate();
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                }
中sql 字符串没有占位符,后面的ps.setString(2,"sql");
就没必要设参数了,多余````

论坛里有相关大的帖子，自己搜搜先！