Question

JAVA编程的问题~~~请高手帮帮忙~~

编写一个界面与数据库交互的程序，要求数据库至少有三个字段，至少实现数据库记录的增加与查询。数据库是SQL。请高手附带说明~~谢谢
这已经是我最后的积分了~

Answer 1

package com.neu.jdbc;

public class JDBCString {
public static final String jdbcDriver="oracle.jdbc.driver.OracleDriver";
public static final String jdbcUrl="jdbc:oracle:thin:@192.168.0.101:1521:ORACLE";
public static final String user="scott";
public static final String passwords="tiger";
}

package com.neu.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.neu.bean.Product;

public class JDBCConn{
String driver = "";
String url = "";
String user = "";
String password = "";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public JDBCConn(){
driver = JDBCString.jdbcDriver;
url = JDBCString.jdbcUrl;
user = JDBCString.user;
password = JDBCString.passwords;
}
public Connection connection(){
Connection cc=null;
try {
Class.forName(driver);
cc = DriverManager.getConnection(url, user, password);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
}
return cc;
}

/*
* 管理员登录表manager
* */
public boolean manager_enter(String manager,String pass) throws SQLException{
boolean tag=false;
conn=connection();
pstmt=conn.prepareStatement("select manager_name,manager_password from manager where manager_name=? and manager_password=?");
pstmt.setString(1, manager);
pstmt.setString(2, pass);
tag=pstmt.execute();
conn.commit();
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
return tag;
}
/*
*
* 用户注册用表login*/
public int insertdate(int userid,String username,String pad,String sex,String address,int tel,String email) throws SQLException{
int i=0;
conn=connection();
pstmt = conn.prepareStatement("insert into login(userid,username,pad,sex,address,tel,email) values(?,?,?,?,?,?,?)");
pstmt.setInt(1,userid);
pstmt.setString(2,username);
pstmt.setString(3, pad);
pstmt.setString(4, sex);
pstmt.setString(5, address);
pstmt.setInt(6, tel);
pstmt.setString(7, email);
i=pstmt.executeUpdate();
System.out.println(i);
conn.commit();
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
return i;
}
/*
* 用户登录login表
* */
public boolean login(String username,String pad) throws SQLException{
boolean tag=false;
conn=connection();
pstmt=conn.prepareStatement("select username,pad from login where username=? and pad=?");
pstmt.setString(1, username);
pstmt.setString(2, pad);
tag=pstmt.execute();
conn.commit();
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
return tag;
}
/*
*
* 查询product中的商品 */
public List selProduct() throws SQLException{
List list=new ArrayList();
conn=connection();
pstmt=conn.prepareStatement("select productid,productsort,productname,productfactory,price,describe from product");
rs=pstmt.executeQuery();
while(rs.next()){
int productId=rs.getInt("productid");
String productSort=rs.getString("productsort");
String productName=rs.getString("productname");
String productFactory=rs.getString("productfactory");
float price=rs.getFloat("price");
String describe=rs.getString("describe");
Product product=new Product();
product.setProductid(productId);
product.setProductSort(productSort);
product.setProductName(productName);
product.setProductFactory(productFactory);
product.setPrice(price);
product.setDescribe(describe);
list.add(product);
}
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
return list;
}

/*
*
*
* 在product表中增加商品*/
public int insertProduct
(int productId,String productSort,String productName,String productFactory,double price,String describe) throws SQLException{
int i=0;
conn=connection();
pstmt=conn.prepareStatement("insert into product values(?,?,?,?,?,?)");
pstmt.setInt(1, productId);
pstmt.setString(2, productSort);
pstmt.setString(3, productName);
pstmt.setString(4, productFactory);
pstmt.setDouble(5, price);
pstmt.setString(6, describe);
i=pstmt.executeUpdate();
conn.commit();
dbClose();
return i;
}

public void dbClose() throws SQLException{
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
}
}

<%@ page language="java" pageEncoding="GBK"%>

<html>
<head>
<title>login.jsp</title>
</head>
<body bgcolor="orange">
<center>
<form action="login" method="post">
<table>
<tr>
<td>用户ID：</td>
<td><input type="text" name="userid"></td>
</tr>
<tr>
<td>用户名：</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密 码：</td>
<td><input type ="password" name="pad"></td>
</tr>
<tr>
<td>性 别：</td>
<td><input type="radio" name="sex">男
<input type="radio" name="sex">女</td>
</tr>
<tr>
<td>地 址：</td>
<td><select name="address">
<option value=liaoning>辽宁</option>
<option value=beijing>北京</option>
<option value=shandong>山东</option>
</select></td>
</tr>
<tr>
<td>电 话：</td>
<td><input type="text" name="tel"></td>
</tr>
<tr>
<td>邮 箱：</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="提交"></td>
</tr>
</table>
</form>
</center>
</body>
</html>

package com.neu.servlet;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.neu.jdbc.JDBCConn;

public class LoginServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// response.setContentType("text/html");
// response.setCharacterEncoding("GBK");
System.out.println("********************************");
JDBCConn jdbc=new JDBCConn();
int userid=Integer.parseInt(request.getParameter("userid"));
String username=request.getParameter("username");
String pad=request.getParameter("pad");
String sex=request.getParameter("sex");
String address=request.getParameter("address");
int tel=Integer.parseInt(request.getParameter("tel"));
String email=request.getParameter("email");
try {

if(jdbc.insertdate(userid, username, pad, sex, address, tel, email)>0){
RequestDispatcher rd=request.getRequestDispatcher("success.html");
rd.forward(request, response);
}
else{
RequestDispatcher rd=request.getRequestDispatcher("failed.jsp");
rd.forward(request, response);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}

以上是我的购物车的用户登录程序，里面还有增加，删除，修改的功能你看看吧

Answer 2

10分谁给你写啊，而且还是SQLserver的。上网查查么，就一个增查应该有例子的

Answer 3

程序不难。。你给的分太吝啬了。。

Answer 4

我给你: Swing 做的.
csdn 里 我叫 luhfly 进去 查我上传的资源 就找到了 关键字 Swing-->Java