当前位置:编程学习 > JSP >>

JSP记事本程序

package guestbook;
import java.sql.*;
public class guestbook{
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:guestbook";
  Connection conn = null;
  ResultSet rs = null;
 
  public guestbook() {
try {
      Class.forName(sDBDriver);  
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("guestbook(): " + e.getMessage());
}
  }
  public void executeInsert(String sql) {
    try {
conn = DriverManager.getConnection(sConnStr);    
     Statement stmt = conn.createStatement();
     stmt.executeUpdate(sql);
    }
    catch(SQLException ex) {   
System.err.println("guestbook.executeUpdate: " + ex.getMessage());
    }
  }
  public ResultSet executeQuery(String sql) {
  rs = null;
    try {
conn = DriverManager.getConnection(sConnStr);    
     Statement stmt = conn.createStatement();
     rs = stmt.executeQuery(sql);
    }
    catch(SQLException ex) {   
System.err.println("guestbook.executeQuery: " + ex.getMessage());
    }
    return rs;
  }
}
<html>
<head>
<title>My First Jsp GuestBook</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#CCCCFF" vlink="#000000" alink="#666666">
<div align="center">
 <p><font size="7"><b><font size="+6">Jsp GuestBook</font></b></font></p>
 <form method="post" action="index.jsp">
  <table width="75%" align="center" border=1>
   <tr>
    <td width="30%">
     <div align="right">Name:</div>
    </td>
    <td width="70%">
     <input type="text" name="name">
    </td>
   </tr>
   <tr>
补充:Jsp教程,Jsp/Servlet开发工具
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,