?? product.java
字號:
package product1;
import java.sql.*;
import java.io.*;
import java.util.Date;
public class product
{
private String id;
private String name;
private String date;
private String address;
private String keep;
private float price;
private int mount;
Connection con;
public String getId()
{
return id;
}
public void setname(String name)
{
this.name=name;
}
public void setdate(String date)
{
this.date=date;
}
public void setaddress(String address)
{
this.address=address;
}
public void setkeep(String keep)
{
this.keep=keep;
}
public void setprice(float price)
{
this.price=price;
}
public void setmount(int mount)
{
this.mount=mount;
}
public String getname()
{
return name;
}
public String getdate()
{
return date;
}
public String getaddress()
{
return address;
}
public String getkeep()
{
return keep;
}
public float getprice()
{
return price;
}
public int getmount()
{
return mount;
}
public void addproduct()throws Exception //增加數據
{
PreparedStatement pstmt=con.prepareStatement("insert into product values(?,?,?,?,?,?)");
pstmt.setString(1,name);
pstmt.setString(2,date);
pstmt.setString(3,address);
pstmt.setString(4,keep);
pstmt.setFloat(5,price);
pstmt.setInt(6,mount);
pstmt.execute();
pstmt.close();
}
public ResultSet find()throws Exception //查找數據
{
try
{
Statement stm=con.createStatement();
ResultSet result=stm.executeQuery("select * from product");
return result;
}catch(Exception e)
{
return null;
}
}
public product()
{
String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String servanddb="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=product";
String user="sa";
String pwd="sa";
try
{
Class.forName(classforname);
con=DriverManager.getConnection(servanddb,user,pwd);
}catch(Exception e)
{}
}
public ResultSet findnum1(String name1)throws Exception
{
try
{
Statement stm=con.createStatement();
ResultSet rest=stm.executeQuery("select * from product where name='"+name1+"'");
return rest;
}catch(Exception e)
{
return null;
}
}
public void update(String name,String date,String address,String keep,String price,String mount,String shi)
{
try
{
Statement stm=con.createStatement();
int col=stm.executeUpdate("update product set name='"+name+"',date='"+date+"',address='"+address+"',keep='"+keep+"',price='"+price+"',mount='"+mount+"' where name='"+shi+"'");
}catch(Exception e)
{
}
}
public void delete(String id)
{
try
{
Statement stm=con.createStatement();
stm.execute("delete from product where name='"+id+"'");
stm.close();
}catch(Exception e)
{}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -