用纯JDBC,不要用JBuilder的控件。例子多得是。
解决方案 »
- 关于JAVA执行 LINUX 下 命令的问题,Runtime.getRuntime().exec(cmd) 的问题
- List<map> list这样定义是什么原因?
- java有用来切图的类吗或是开源的项目
- 关于JComponent.repaint(Graphics g,int x,int y,int width,int height) 与 paintComponent()
- DWR框架的反向Ajax技术问题
- 关于提示窗口的小问题????????????
- 为什么这段代码不能实现线程同步?
- JAVA程序员出去面试,主要问什么啊?
- 初学者:一个函数参数的问题,请大家帮忙!
- java调用C/C++编写的DLL文件问题,请有经验的高手指教?
- 打开jar发现包名,类名均为a,b,c 之流何故?
- 一个关于 thread 的问题,高手请指教
该例子有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() {
}
}
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);
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();
}
}