!!!!紧急求救jsp 高手 紧急求救jsp 高手 我刚学jsp , 紧急求救jsp 高手在jsp页面中,我要实现如下功能一道英语题的答案有四个选项(单选题)A 22 B dfgds C fgdg D fg 我要用单选框 来实现选择,并将选项插入数据库中问题一.数据如何从页面插入数据库?代码如何编写? 问题二.默认情况下是哪个都不选择,象这样的空值能插入数据库吗,如何将这样的空值插入数据库中?代码如何写? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 有意思 给你一段代码参考下吧 ..连接的是oracleimport javax.servlet.*;import javax.servlet.http.*;import java.sql.*;import java.util.*;import java.io.*;public class AddMessageServlet extends HttpServlet{ private Connection con; public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { String name=request.getParameter("name"); String mail=request.getParameter("email"); String title=request.getParameter("title"); String content=request.getParameter("content"); if(name==null) name=""; if(title==null) title=""; if(content==null) content=""; if(mail==null) mail=""; try { PreparedStatement stm=con.prepareStatement("insert into message values(?,?,?,?,?)"); stm.setString(1,title); stm.setString(2,name); if(mail.length()==0) stm.setString(5,null); else stm.setString(5,mail); stm.setDate(3,new java.sql.Date(new java.util.Date().getTime())); stm.setString(4,content); try { stm.executeQuery(); } catch(Exception e) { } RequestDispatcher requestDispatcher = request.getRequestDispatcher("/viewMessages_servlet"); requestDispatcher.forward(request,response); } catch(Exception e) { e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { doGet(request,response); } public AddMessageServlet() { String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev"; String USER="bn"; String PWD="bn"; try { Class.forName(CLASSFORNAME); con = DriverManager.getConnection(SERVANDDB,USER,PWD); } catch(Exception e) { e.printStackTrace(); } } } 二楼的大哥,你用的是不是Servlet技术啊这东西太高深了,我玩不了有没有简单些的还有jsp页面中的单选框该怎么写呢 前面网页部分把要提交的数据放到一个Form中。在JSP中通过request.getParameter("selected");获取提交项。 这些我也知道,可是我不会写在jsp页面中的关于jsp页面中的单选框的代码 给你一个:<td align="center" nowrap class="datacheck" ><input type=checkbox name=checkbox id=<%=i%>></td> 谢谢啊,这点我知道但是在jsp页面中,我要实现如下功能 一道英语题的答案有四个选项(单选题) A 22 B dfgds C fgdg D fg 有四个选项,应怎么写呢,而且四个中只能选中一个,怎么传选中的这个呢 <input type=radio name="answer" value="A">A. 22<br><input type=radio name="answer" value="B">B. dfgds<br><input type=radio name="answer" value="C">C. fgdg<br><input type=radio name="answer" value="D">D. fg<br> import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;import java.util.*;import java.io.*;public class AddMessageServlet extends HttpServlet{ private Connection con; public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { String name=request.getParameter("name"); String mail=request.getParameter("email"); String title=request.getParameter("title"); String content=request.getParameter("content"); if(name==null) name=""; if(title==null) title=""; if(content==null) content=""; if(mail==null) mail=""; try { PreparedStatement stm=con.prepareStatement("insert into message values(?,?,?,?,?)"); stm.setString(1,title); stm.setString(2,name); if(mail.length()==0) stm.setString(5,null); else stm.setString(5,mail); stm.setDate(3,new java.sql.Date(new java.util.Date().getTime())); stm.setString(4,content); try { stm.executeQuery(); } catch(Exception e) { } RequestDispatcher requestDispatcher = request.getRequestDispatcher("/viewMessages_servlet"); requestDispatcher.forward(request,response); } catch(Exception e) { e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { doGet(request,response); } public AddMessageServlet() { String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev"; String USER="bn"; String PWD="bn"; try { Class.forName(CLASSFORNAME); con = DriverManager.getConnection(SERVANDDB,USER,PWD); } catch(Exception e) { e.printStackTrace(); } } }这明明是SQLServer的连接呀..怎么是oracle了.这个才是oracle package oracle.common;import java.sql.Connection;import java.sql.DriverManager;import java.util.Properties;import javax.swing.*;import java.awt.event.MouseEvent;public class DBConnection { public static Connection getOracleConnection() { Connection con = null; Properties properties = new Properties(); properties.put("user", "crm"); properties.put("password", "crm"); try { Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:East", properties); } catch (Exception e) { e.printStackTrace(); } JLabel labl=new JLabel(); return con; }} 这次短些。自己实现的JMS远程方法调用。 Private变量 还是关于JTable表格大小的改变 小问题 郁闷ing,这是什么情况 如何正确读取文本文件 哪个有jdk帮助文档 一个久而未决的问题,有三个贴子 问一下关于JInternalFrame的问题(有点难度) 关于对话框的简单问题,20分!! 大家帮我调试一个小程序,关于instanceof 请教简单容器问题?
给你一段代码
参考下吧 ..
连接的是oracle
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
import java.io.*;
public class AddMessageServlet extends HttpServlet
{ private Connection con;
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
String name=request.getParameter("name");
String mail=request.getParameter("email");
String title=request.getParameter("title");
String content=request.getParameter("content");
if(name==null)
name="";
if(title==null)
title="";
if(content==null)
content="";
if(mail==null)
mail="";
try
{
PreparedStatement stm=con.prepareStatement("insert into message values(?,?,?,?,?)");
stm.setString(1,title);
stm.setString(2,name);
if(mail.length()==0)
stm.setString(5,null);
else stm.setString(5,mail);
stm.setDate(3,new java.sql.Date(new java.util.Date().getTime()));
stm.setString(4,content);
try
{
stm.executeQuery();
}
catch(Exception e)
{
} RequestDispatcher requestDispatcher = request.getRequestDispatcher("/viewMessages_servlet");
requestDispatcher.forward(request,response);
}
catch(Exception e)
{
e.printStackTrace();
}
} public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doGet(request,response);
}
public AddMessageServlet()
{
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
String USER="bn";
String PWD="bn";
try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
这东西太高深了,我玩不了
有没有简单些的
还有jsp页面中的单选框该怎么写呢
在JSP中通过request.getParameter("selected");获取提交项。
这些我也知道,可是我不会写在jsp页面中的关于jsp页面中的单选框的代码
<td align="center" nowrap class="datacheck" ><input type=checkbox name=checkbox id=<%=i%>></td>
但是在jsp页面中,我要实现如下功能
一道英语题的答案有四个选项(单选题)
A 22 B dfgds C fgdg D fg 有四个选项,应怎么写呢,而且四个中只能选中一个,怎么传选中的这个呢
<input type=radio name="answer" value="B">B. dfgds<br>
<input type=radio name="answer" value="C">C. fgdg<br>
<input type=radio name="answer" value="D">D. fg<br>
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
import java.io.*;
public class AddMessageServlet extends HttpServlet
{ private Connection con;
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
String name=request.getParameter("name");
String mail=request.getParameter("email");
String title=request.getParameter("title");
String content=request.getParameter("content");
if(name==null)
name="";
if(title==null)
title="";
if(content==null)
content="";
if(mail==null)
mail="";
try
{
PreparedStatement stm=con.prepareStatement("insert into message values(?,?,?,?,?)");
stm.setString(1,title);
stm.setString(2,name);
if(mail.length()==0)
stm.setString(5,null);
else stm.setString(5,mail);
stm.setDate(3,new java.sql.Date(new java.util.Date().getTime()));
stm.setString(4,content);
try
{
stm.executeQuery();
}
catch(Exception e)
{
} RequestDispatcher requestDispatcher = request.getRequestDispatcher("/viewMessages_servlet");
requestDispatcher.forward(request,response);
}
catch(Exception e)
{
e.printStackTrace();
}
} public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doGet(request,response);
}
public AddMessageServlet()
{
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
String USER="bn";
String PWD="bn";
try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
}
}这明明是SQLServer的连接呀..怎么是oracle了.这个才是oracle
package oracle.common;import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import javax.swing.*;
import java.awt.event.MouseEvent;public class DBConnection {
public static Connection getOracleConnection() {
Connection con = null;
Properties properties = new Properties();
properties.put("user", "crm");
properties.put("password", "crm");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:East", properties);
} catch (Exception e) {
e.printStackTrace();
}
JLabel labl=new JLabel();
return con;
}
}