java 库存表

库存表"/>

java 库存表

1、建立一个表，分别有Coursename,teachername,Place,Id;这些数据跟sql语句中的相对应

2、在src包目录下创建这些类

3、在WebContent目录下创建jsp，Main.jsp和Add.jsp。

4、添加mysql包(网上都有，自行下载，复制过去就行)

然后构建路径：右键这个包->Build path->Add to Build Path

5、快乐的复制代码就行了

//User类

public class User {

private String teachername;

private String place;

private String classname;

private String id;

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getTeachername() {

return teachername;

}

public void setTeachername(String teachername) {

this.teachername = teachername;

}

public String getPlace() {

return place;

}

public void setPlace(String place) {

this.place = place;

}

public String getClassname() {

return classname;

}

public void setClassname(String classname) {

this.classname = classname;

}

}

//UserDao类

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class UserDao {

public void add(User user) {

//获得链接对象

Connection connection = DBUtil.getConnection();

//准备sql语句

String sql = "insert into test(Coursename,Teachername,Place,Id)values(?,?,?,?)";

PreparedStatement preparedStatement = null;

try {

//创建语句传输对象

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setString(1, user.getTeachername());

preparedStatement.setString(2, user.getClassname());

preparedStatement.setString(3, user.getPlace());

preparedStatement.setString(4, user.getId());

preparedStatement.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

//关闭资源

DBUtil.close(preparedStatement);

DBUtil.close(connection);

}

}

}

//DBUtil类

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUtil {

@SuppressWarnings("resource")

public static Connection getConnection() {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String user = "root";

String password = "001206";

String url = "jdbc:mysql://localhost/users1";

Connection connection = null;

try {

connection = DriverManager.getConnection(url,user,password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return connection;

}

public static void close(Connection connection ) {

try {

if (connection != null) {

connection.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void close(PreparedStatement preparedStatement ) {

try {

if (preparedStatement != null) {

preparedStatement.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void close(ResultSet resultSet ) {

try {

if (resultSet != null) {

resultSet.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

//Main.jsp

pageEncoding="UTF-8"%>

Insert title here

String s=(String)request.getAttribute("Error");

if("".equals(s)||s==null)

{

s="";

}

%>

课程名称

任课教师

上课地点

学号

//Add.jsp

pageEncoding="UTF-8"%>

Insert title here

int i=0;

boolean flag=true;

boolean flag1=true;

String s[]={"王建民","刘丹","刘立嘉","杨子光","王辉"};

String s1[]={"基教","一教","二教","三教"};

String name=request.getParameter("name");

String teacher=request.getParameter("teacher");

String place=request.getParameter("place");

String id=request.getParameter("id");

while(i

{

if(!s[i].equals(teacher))

{

flag=false;

}

else

{

flag=true;

break;

}

i++;

}

%>

if(!flag)

{

request.setAttribute("Error", "老师不对");

%>

}

i=0;

String s3=place.substring(0,2);

while(flag==true&&i

{

if(!s1[i].equals(s3)){

flag1=false;

}

else

{

flag1=true;

break;

}

i++;

}

if(!flag1)

{

request.setAttribute("Error", "教室不对");

%>

}

UserDao userdao=new UserDao();

User user=new User();

user.setClassname(name);

user.setTeachername(teacher);

user.setPlace(place);

user.setId(id);

userdao.add(user);

%>

6、运行界面

最后感谢您的观看，有什么问题或者不懂的地方可以评论到下方，非常感谢您的宝贵建议。