JAVA GUI的前端加上Mysql的后台算是cs架构吗？？请教一下

c/s 架构指的是 client/server ，其中的client 指客户端，

b/s 架构指的是brower/server ,其中的 brower 指浏览器。

而 java/GUI 属于 client ，所以是 c/s 架构。

基于网页开启的属于 b/s 构架。

int i = 101

String str = "XX"

String sql = "CREATE TABLE table_"+ i +"_"+str+" (id .....)"

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

Connection conn = DriverManager.getConnection(url,userName,pwd)

Statement stmt = conn.createStatement()

stmt.executeUpdate(sql)

首先正确安装好MySQL，建立好数据库studentinfo

mysql>create database studentinfo

然后编写java代码，ConnectToMySQL.java

import java.sql.*

public class ConnectToMySQL {

public static Connection getConnection() throws SQLException ,

java.lang.ClassNotFoundException{

String url = "jdbc:mysql://localhost:3306/studentinfo"

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

String userName = "root"

String password = ""

Connection con = DriverManager.getConnection(url,userName,password)

return con

}

public static void main(String[] args) {

try{

Connection con = getConnection()

Statement sql = con.createStatement()

sql.execute("drop table if exists student")

sql.execute("create table student(id int not null auto_increment,name varchar(20) not null default 'name',math int not null default 60,primary key(id))")

sql.execute("insert student values(1,'AAA','99')")

sql.execute("insert student values(2,'BBB','77')")

sql.execute("insert student values(3,'CCC','65')")

String query = "select * from student"

ResultSet result = sql.executeQuery(query)

System.out.println("Student表数据如下：")

System.out.println("---------------------------------")

System.out.println("学号"+" "+"姓名"+" "+"数学成绩")

System.out.println("---------------------------------")

int number

String name

String math

while(result.next()){

number = result.getInt("id")

name = result.getString("name")

math = result.getString("math")

System.out.println(number + " " + name + " " + math)

}

sql.close()

con.close()

}catch(java.lang.ClassNotFoundException e){

System.err.println("ClassNotFoundException:" + e.getMessage())

}catch(SQLException ex){

System.err.println("SQLException:" + ex.getMessage())

}

}

}

很详细了。

---