package com.apple.struts;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MyBean {
 private String username;

 private String password;

 private Statement stmt;

 private Connection conn;

 private String isbn;

 private String name;

 private String prize;

 public String getPassword() {
  return password;
 }

 public void setPassword(String password) {
  this.password = password;
 }

 public String getUsername() {
  return username;
 }

 public void setUsername(String username) {
  this.username = username;
 }

 public void conn() {
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookonline";

  try {
   conn = DriverManager.getConnection(URL, "sa", "gatj831023");

   stmt = ((java.sql.Connection) conn).createStatement();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 public boolean process() {
  int k = 0;
  try {
   conn();
   
   String sql = "select * from userinfo where user_name='" + username
     + "'" + "and user_password='" + password + "'";
   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    k++;
   }
   conn.close();
   stmt.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  if (k > 0) {
   return true;
  } else {
   return false;
  }
 }

 public ShoppingCart Getbook() {
  int k = 0;
  ShoppingCart allbook = null;
  try {
   conn();
   String sql = "select * from bookinfo";
   ResultSet rs = stmt.executeQuery(sql);
   allbook = new ShoppingCart();
   while (rs.next()) {
    prize = rs.getString("prize");
    name = rs.getString("name");
    isbn = String.valueOf(rs.getInt("isbn"));
    Book newbook = new Book();
    newbook.setName(name);
    newbook.setPrize(prize);
    newbook.setIsbn(isbn);
    allbook.addBook(newbook);
    k++;
   }
   conn.close();
   stmt.close();

  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return allbook;

 }

 public boolean adduser() {
  boolean adduserIs = false;
  
  try {
   conn();
   String sqlname = "select * from userinfo where user_name='" + username + "'";
   ResultSet rs = stmt.executeQuery(sqlname);
   if (rs.next()) {
    adduserIs = true;

   }else{
   String sql = " insert userinfo (user_name,user_password) "
     + "values ('" + username + "','" + password + "')";
   
   adduserIs = stmt.execute(sql);
   System.out.println(adduserIs);
   conn.close();
   stmt.close();
   
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return adduserIs;
 }
}
 

发表于 @ 2007年03月29日 20:33:00|编辑