-----------请问各位，有没有用JBUILDER操作数据库的实例原码，不是用组件-------时刻在线等待！！！------

Question

用纯JDBC,不要用JBuilder的控件。例子多得是。

Answer 1

给你一段代码，可能有点复杂，我来不及整理了，需要的话，我可以将整个例子都给你，给我你的邮件地址。我的是[email protected]
该例子有jsp<-->oracle,servlet<---->oracle等。
-------------------------------------------------------------
package stuff;import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;public class insert_person_info extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=Shift_JIS";
  /**Initialize global variables*/
  public void init() throws ServletException {
  }
  /**Process the HTTP Post request*/
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    response.setContentType(CONTENT_TYPE);
    PrintWriter toClient = response.getWriter();
    FileWriter resultsFile=new FileWriter("./"+System.getProperty("file.separator")+"savedata.txt",true);
    PrintWriter toFile = new PrintWriter(resultsFile);    int id=Integer.parseInt(request.getParameterValues("id")[0]);
    byte[] name_from_jsp=request.getParameterValues("name")[0].getBytes("ISO8859-1");
    String name=new String(name_from_jsp);
    int age=Integer.parseInt(request.getParameterValues("age")[0]);
    byte[] address_from_jsp=request.getParameterValues("address")[0].getBytes("ISO8859-1");
    String address=new String(address_from_jsp);    String login_date=(request.getParameterValues("login_date")[0]);
    try
       {
           Enumeration values=request.getParameterNames();
           toFile.println("<BEGIN>");
           toFile.println("恖堳斣崋丗"+":"+String.valueOf(id)/*request.getParameterValues("id")[0]*/);
           toFile.println("柤慜丗"+":"+name/*request.getParameterValues("name")[0]*/);
           toFile.println("擭楊丗"+":"+String.valueOf(age)/*request.getParameterValues("age")[0]*/);
           toFile.println("廧強丗"+":"+address/*request.getParameterValues("address")[0]*/);
           toFile.println("搊榐帪娫丗"+":"+login_date/*request.getParameterValues("login_date")[0]*/);
      /*     while (values.hasMoreElements())
              {
                  String name=(String)values.nextElement();
                  String value=request.getParameterValues(name)[0];
                  if (name.compareTo("Submit")!=0)
                    {
                        toFile.println(name+":"+value);
                    }
              }
              */
           toFile.println("<END>");
           resultsFile.close();
       }
    catch(IOException e)
       {
           e.printStackTrace();
           toClient.println("a problen occured while recording to your answers."+"please try again.");
       }
    String sDBDriver="oracle.jdbc.driver.OracleDriver";
    String SConnstr="jdbc:oracle:thin:@sunxiaoming:1521:sxm";
/*odbc connect
   String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
   String sConnStr="jdbc:odbc:faq";*/
    Connection conn=null;
    ResultSet rs=null;
    try
         {
             Class.forName(sDBDriver);
             conn = DriverManager.getConnection(SConnstr,"sunxiaoming","sunxiaoming");
             Statement stmt=conn.createStatement();
             String sql="insert into person_information (ID,NAME,AGE,ADDRESS,LOGIN_DATE) values ('"+id+"','"+name+"','"+age+"','"+address+"','"+login_date+"')";
             rs=stmt.executeQuery(sql);
             toClient.println("擖椡惉岟両偍傔偱偲偆両");
/*odbc connect
            conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
*/
         }
    catch(java.sql.SQLException e)
         {
             toClient.println("sqlexception error!");
             toClient.println(e.getMessage());
         }
    catch(java.lang.ClassNotFoundException e)
         {
             toClient.println("ClassNotFoundException error has founded!");
             toClient.println(e.getMessage());
         }
    toClient.close();
  }
  /**Clean up resources*/
  public void destroy() {
  }
}

Answer 2

String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBLocation = "jdbc:oracle:thin:@111.111.111.111:1521:orc1";
String DBUser = "111";
String DBPwd = "111"; Class.forName(DBDriver);
Connection conn = DriverManager.getConnection(DBLocation, DBUser, DBPwd);

Answer 3

package access;
import java.sql.*;
import java.text.*;public class access_dbconnect
{
        //String  dbdriver = "oracle.jdbc.driver.OracleDriver";
//String  dbname = "jdbc:oracle:thin:@192.168.0.240:1521:caihong";
//String  dbname = "jdbc:oracle:thin:@sgh:1521:sght"; String dbdriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbname = "jdbc:odbc:Access_test";
String  user = "";
String password = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs =null;
       public access_dbconnect(){
              try
  {
                  Class.forName(dbdriver);
                  conn=DriverManager.getConnection(dbname,user,password);
                  stmt=conn.createStatement();   }
              catch(Exception e){
                    System.err.println("Class access_dbconnect not fount!"+e.getMessage());
                   }
       }       public void init()
   {
          try
  {
                  conn=DriverManager.getConnection(dbname,user,password);
                  stmt=conn.createStatement();   }
              catch(Exception e)
  {
                    System.err.println("Class access_dbconnect not fount!"+e.getMessage());
                   }    }
   public ResultSet executeQuery(String sql){              try{                  rs=stmt.executeQuery(sql);                  if(rs == null)     //**********************************
                {
                  System.out.println("can't get ResultSet"); //**********************************
                }                    //**********************************               }
              catch(SQLException ex){
                     System.err.println("aq.executeQuery:"+ex.getMessage());
               }
               return rs;       }       public ResultSet executeUpdate(String sql){              try
  {
                  rs=stmt.executeQuery(sql);
             }
              catch(SQLException ex){
                    System.err.println("aq.executeQuery:"+ex.getMessage());
             }
             return rs;
    }
  public void close()
  {
    try
{
    this.conn.close();
    this.stmt.close();     }
 catch(Exception e)
 {
    e.printStackTrace();
 }
  }
  public void showHtml(HttpServletRequest request,HttpServletResponse response,String message) throws IOException
{
        PrintWriter out = response.getWriter(); out.println(message);
}public static void main(String args[])
{
access_dbconnect  con = new access_dbconnect();
con.init();
ResultSet res = con.executeQuery("select * from user_info");
String name = "";
String name2 = "";
HttpServletRequest request = new HttpServletRequest();
HttpServletResponse response = new HttpServletResponse();
con.showHtml( request,response,"test");
try
{
while(res.next())
{
name = res.getString("name"); System.out.println(name); }
res.close();
}
catch( SQLException e)
{
         e.printStackTrace();
} con.close();
}
}