数据库问题请教！

**************add*******************
public void add()
 { try
 {
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection cn=DriverManager.getConnection("jdbc:odbc:wordboard");
 str="INSERT INTO message(name,email,topic,msgtime,note) VALUES ('"+get_Name+"','"+get_Email+"','"+get_Topic+"','"+get_Time+"','"+get_Note+"')";
 Statement st=cn.createStatement();
 st.executeUpdate(str); <<<<<<<<<<<<<<<<<<填加操作
 st.close();
 cn.close();
 }
 catch(Exception ex )
{
System.out.println(ex.getMessage());

}
 }**************seletc************
conn = DriverManager.getConnection(sConnStr);
 stmt = conn.createStatement();
 rs = stmt.executeQuery(sql); <<<<<<<<查询 sql是一个字符串就相当与你的查询语句
 } 修改和删除就是你自己的 sql 语句问题了 executeQuery executeUpdate 主要是这两个函数你要明白

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

/*
* DBconn.java
*/
package dataBean;import java.sql.*;
public class DBconn
  {
String dbDriver="org.gjt.mm.mysql.Driver";
String conStr="jdbc:mysql://localhost:3306/3dsoft";
String myUser="root";
String myPassword="";
    Connection con = null;
    ResultSet rs = null;
   public DBconn()
     {
   try
        {
         Class.forName(dbDriver);
        }
      catch(java.lang.ClassNotFoundException e)
        {
         System.err.println("DBconn (): " + e.getMessage());
        }
     }   public String getDbDriver()
{
return dbDriver;
}
public void setDbDriver(String  dbDriver)
{
this.dbDriver=dbDriver;
}
public String  getConStr()
  {
return  conStr;
  }
public void  setConStr(String  conStr )
  {
this.conStr = conStr  ;
  }
public String getMyUser()
  {
return myUser  ;
  }
public void  setMyUser(String  myUser )
  {
this. myUser= myUser  ;
  }
  public String  getMyPassword()
  {
return  myPassword ;
  }
public void setMyPassword(String myPassword )
  {
this.myPassword =  myPassword ;
  }
   public ResultSet executeQuery(String sql)  throws SQLException, Exception
    {
      rs = null;
    try
       {
         con = DriverManager.getConnection(conStr,myUser,myPassword);
          Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
          rs = stmt.executeQuery(sql);
        }
catch(SQLException ex)
        {
System.err.println("executeQuery:"+ex.getMessage());
return null;
}
catch(Exception e)
        {
System.err.println("executeQuery:"+e.getMessage());
return null;
}
return rs;
     } public  int  executeUpdate(String sql)
  {
int n=0;
try
        {
         con = DriverManager.getConnection(conStr,myUser,myPassword);
          Statement stmt = con.createStatement();
          n=stmt.executeUpdate(sql);
        }
      catch(SQLException ex)
        {
System.err.println("executeUpdate:"+ex.getMessage());
return 0;
        }
catch(Exception e)
        {
System.err.println("executeQuery:"+e.getMessage());
return 0;
}
return n;
     }

}
调用javabean !<%@page contentType="text/html;charset=gb2312"%>
<%@page language="java" import="java.sql.*" %>
<jsp:useBean id="DBconn" scope="session" class="Show.DBconn"/>
<html>
 <head>
　　<title>Show MySQL!</title>
　</head>
　<body>
<%String sql;
int result=0;sql="insert into information (name,sex,code) values('哈哈','男','111');
result=DBconn.executeUpdate(sql); //执行添加数据!
//判断是否正确执行!
if(result==0)
{
response.sendRedirect("error.jsp");
}
%>
 
 
 新数据已经被成功添加 :
</BODY>
</HTML>查询，修改，删除的方法类似 ! 查询使用rs.executeQuery()
谢谢楼上的朋友，不过楼上所说的其实是把SQL语句嵌入到代码中，这样我要添加一条记录的话，还得到代码中改，我想做的是在网页中嵌个表格，里面显示出数据，我可以即时的对数据进行添加，删除，修改等操作，我现在就是不知道如何传递它们之间的参数！如何让修改的数据返回到数据库！请赐教！
java.util.Enumeration keys = request.getParameterNames();
while (keys.hasMoreElements());
{
key = (String) keys.nextElement();
if (key.equalsIgnoreCase("name"))name = request.getParameter(key);
else if (key.equalsIgnoreCase("address"))address = request.getParameter(key);
else if (key.equalsIgnoreCase("mail"))mail = request.getParameter(key);
  else if (key.equalsIgnoreCase("tel"))tel = request.getParameter(key);
      else;
在表格页上起好各个输入框名字