怎么往数据库里写数据!!最好给个事例,谢谢 这个问题也问?我就不信你没有一本Java的书籍!晕倒! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 String text = request.getParameter("tt");用INSERT INTO 表名(你的字段)values('"+text+"');tt:前台输入的变量名。在第二个页面用text变量接受然后插入到表中你的字段中就可以了啊 还是找本书看看吧,用sql语句啊,在java中执行这个语句就可以了啊!看书吧! 不知楼主用的什么数据库,但不管什么数据库,大体步骤是如此的:1。加载数据库驱动程序。以SQLSERVER为例: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");2。得到数据库的连接: conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NCbbs;user=sa;password=lovewei;");3。得到执行SQL语句的对象并执行SQL语句:给出如下代码:QueryBean.java: pacakage operate_db; /** * Title: select insert update and delete * Description: select insert update and delete * Copyright: Copyright (c) 2001 * @author Lci21 * @version 1.0 */ import java.sql.*; public class QueryBean { public String query_statement; /*定义sql语句*/ public String param[]; /*查询条件,或者是新的记录*/ public ResultSet result=null; public Connection conn; public void setParam(String[] param) { this.param=param; } public void setQuerystatement(String query_statement) { this.query_statement=query_statement; } public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception { Connection conn1; Class.forName(driverName); conn1=DriverManager.getConnection(jdbcURL,username,passwd); conn1.setAutoCommit(false); this.conn = conn1; } /*获取查询结果*/ public ResultSet getResult() { try { PreparedStatement select_stm=conn.prepareStatement(query_statement,java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); if (param!=null) for(int i=0;i<param.length;i++) select_stm.setString(i+1,param[i]); result=select_stm.executeQuery(); }catch(Exception e){System.out.println(e);} return result; } /*对数据库进行增加记录操作*/ public void insertRecord() throws SQLException,java.io.UnsupportedEncodingException { try { PreparedStatement insert_stm=conn.prepareStatement(query_statement); if (param!=null) for(int i=0;i<param.length;i++) insert_stm.setString(i+1,param[i]); insert_stm.executeUpdate(); insert_stm.close(); conn.commit(); } catch(Exception e) { System.out.println(e); conn.rollback(); } } /*对数据记录进行更改操作*/ public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException { try { PreparedStatement update_stm=conn.prepareStatement(query_statement); if (param!=null) for (int i=0;i<param.length;i++) update_stm.setString(i+1,param[i]); update_stm.executeUpdate(); update_stm.close(); conn.commit(); } catch(Exception e) { System.out.println(e); conn.rollback(); } } /*删除数据记录*/ public void deleteRecord() throws SQLException,java.io.UnsupportedEncodingException { try { PreparedStatement delete_stm=conn.prepareStatement(query_statement); if (param!=null) for (int i=0;i<param.length;i++) delete_stm.setString(i+1,param[i]); delete_stm.executeUpdate(); delete_stm.close(); conn.commit(); } catch(Exception e) { System.out.println(e); conn.rollback(); } } } 找本java的书或者找个有调jdbc的地方,public class CreateCoffees { public static void main(String args[]) { String url = "jdbc:mysql://localhost/myDataSource"; Connection con; String createString; createString = "create table COFFEES " + " (COF_NAME varchar(32), " + " SUP_ID int, " + " PRICE float, " + " SALES int, " + " TOTAL int)"; Statement stmt; try { Class.forName("org.gjt.mm.mysql.Driver"); } catch (java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } try { con = DriverManager.getConnection(url, "", ""); stmt = con.createStatement(); stmt.executeUpdate(createString); stmt.close(); con.close(); } catch (SQLException ex) { System.err.println("SQLException: " + ex.getMessage()); } }}大都都这样的,只是可能加载驱动,和url的地方有点不同 jsp嵌入media player 如何让浏览器自动安装解码包 非常郁闷的一个问题 xmlhttp 传checkbox 中文乱码?? 刷新相当于添加一条记录 求救!关于James发送邮件到远程服务器的问题 smartupload 动态下拉框的问题 在tomcat中如何配置java_home,在线等待!!! 动态生成几行RADIO按钮的问题 substring(1,20)??? JSP能做多媒体网站吗?进来就有分
用INSERT INTO 表名(你的字段)values('"+text+"');tt:前台输入的变量名。在第二个页面用text变量接受
然后插入到表中你的字段中就可以了啊
1。加载数据库驱动程序。以SQLSERVER为例:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
2。得到数据库的连接:
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NCbbs;user=sa;password=lovewei;");
3。得到执行SQL语句的对象并执行SQL语句:
给出如下代码:QueryBean.java: pacakage operate_db;
/**
* Title: select insert update and delete
* Description: select insert update and delete
* Copyright: Copyright (c) 2001
* @author Lci21
* @version 1.0
*/ import java.sql.*;
public class QueryBean
{
public String query_statement; /*定义sql语句*/
public String param[]; /*查询条件,或者是新的记录*/
public ResultSet result=null;
public Connection conn; public void setParam(String[] param)
{
this.param=param;
}
public void setQuerystatement(String query_statement)
{
this.query_statement=query_statement;
}
public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
{
Connection conn1;
Class.forName(driverName);
conn1=DriverManager.getConnection(jdbcURL,username,passwd);
conn1.setAutoCommit(false);
this.conn = conn1;
}
/*获取查询结果*/
public ResultSet getResult()
{
try
{
PreparedStatement select_stm=conn.prepareStatement(query_statement,java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
if (param!=null)
for(int i=0;i<param.length;i++)
select_stm.setString(i+1,param[i]);
result=select_stm.executeQuery();
}catch(Exception e){System.out.println(e);}
return result;
} /*对数据库进行增加记录操作*/
public void insertRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
PreparedStatement insert_stm=conn.prepareStatement(query_statement);
if (param!=null)
for(int i=0;i<param.length;i++)
insert_stm.setString(i+1,param[i]);
insert_stm.executeUpdate();
insert_stm.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
} /*对数据记录进行更改操作*/
public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
PreparedStatement update_stm=conn.prepareStatement(query_statement);
if (param!=null)
for (int i=0;i<param.length;i++)
update_stm.setString(i+1,param[i]);
update_stm.executeUpdate();
update_stm.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
/*删除数据记录*/
public void deleteRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
PreparedStatement delete_stm=conn.prepareStatement(query_statement);
if (param!=null)
for (int i=0;i<param.length;i++)
delete_stm.setString(i+1,param[i]);
delete_stm.executeUpdate();
delete_stm.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
}
public class CreateCoffees { public static void main(String args[]) { String url = "jdbc:mysql://localhost/myDataSource";
Connection con;
String createString;
createString = "create table COFFEES "
+ " (COF_NAME varchar(32), "
+ " SUP_ID int, "
+ " PRICE float, "
+ " SALES int, "
+ " TOTAL int)";
Statement stmt; try {
Class.forName("org.gjt.mm.mysql.Driver"); } catch (java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
} try {
con = DriverManager.getConnection(url, "", ""); stmt = con.createStatement();
stmt.executeUpdate(createString); stmt.close();
con.close(); } catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}大都都这样的,只是可能加载驱动,和url的地方有点不同